Skip to main content

I’m unable to insert new record in table.

Query:

INSERT INTO Ocustomer-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.

This Runs :

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


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. 


Reply