Skip to main content
K
KarunaB
Cadet | Tier 2
January 25, 2025
Solved

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

  • January 25, 2025
  • 2 replies
  • 94 views

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
    KarunaBAuthorAnswer
    Cadet | Tier 2
    January 25, 2025

    This Runs :

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

      Aaron.Gleason
      Automation Anywhere Team
      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 & ConditionsAccessibility statement