Question

Processing Excel as DB using the INSERT and getting the following Syntax Error when gets to INSERT statement. Can anyone help? There was a problem at line 38 This may be due to the following reason: - There is a syntactical error in the SQL statement


Screenshot 2022-05-24 132905


2 replies

Userlevel 6
Badge +9

Hi @Sandy Norris​ ,

 

Good day!

 

Please refer the below KB article for the reported concern and follow the steps.

 

https://apeople.automationanywhere.com/s/article/Excel-as-Database-commands-fail-to-execute-with-Syntactical-Error/p>

 

Badge

Hi,

try this 

INSERT INTO [COYOTESheet$$]

Reply