Skip to main content
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
  • 214 views
S
Forum|alt.badge.img+1

Screenshot 2022-05-24 132905

    2 replies

    A
    Automation Anywhere Team
    Forum|alt.badge.img+12

    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
    Forum|alt.badge.img
    • Aaron 6185
    • Cadet | Tier 2
    • July 13, 2023

    Hi,

    try this 

    INSERT INTO [COYOTESheet$$]

    Terms & ConditionsCookie settingsAccessibility statement