Skip to main content
S
SNorris
Cadet | Tier 2
May 24, 2022
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

  • May 24, 2022
  • 2 replies
  • 264 views

Screenshot 2022-05-24 132905

    2 replies

    A
    Automation Anywhere Team
    Automation Anywhere Team
    Automation Anywhere Team
    June 14, 2022

    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>

     

    A
    Aaron 6185
    Cadet | Tier 2
    July 13, 2023

    Hi,

    try this 

    INSERT INTO [COYOTESheet$$]

    Terms & ConditionsAccessibility statement