Skip to main content
Answer

Unable to insert new record in table. (CSV as DB)

  • January 25, 2025
  • 2 replies
  • 34 views
K
Forum|alt.badge.img+2

I’m unable to insert new record in table.

Query:

INSERT INTO [customer-onboarding-challenge.csv] (Company Name,Customer ID,Primary Contact,Street Address,City,State,Zip,Email,Address,Offers Discounts,Non-Disclosure On File) VALUES ('1','2','3','4','5','6','7,'8','9','10')

Error:

There is a syntactical error in the SQL statement.

Best answer by KarunaB

This Runs :

INSERT INTO [customer-onboarding-challenge.csv] values (1,2,3,4,5,6,7,8,9,10)

    2 replies

    K
    Forum|alt.badge.img+2
    • KarunaB
    • Author
    • Cadet | Tier 2
    • Answer
    • January 25, 2025

    This Runs :

    INSERT INTO [customer-onboarding-challenge.csv] values (1,2,3,4,5,6,7,8,9,10)

    Aaron.Gleason
    Aaron.Gleason
    Automation Anywhere Team
    Forum|alt.badge.img+14
    • Aaron.Gleason
    • Automation Anywhere Team
    • January 25, 2025

    Thank you for posting your solution. To anyone having similar problems, when you're trying to use SQL statements with non-database objects like this, just know it is not necessarily going to follow standard SQL syntax. You will have to mess around with it until you find exactly what the connector expects. I frequently use connectionstrings.com to help me figure it out. 

    Terms & ConditionsCookie settingsAccessibility statement