Skip to main content
Cadet | Tier 2
November 15, 2021
Question

Excel file as a DB - SELECT Statement

  • November 15, 2021
  • 2 replies
  • 458 views

Hello,

I am using Automation Anywhere Community Edition.

 

I want to use an Excel file as a DB.

I have successfully created the connection.

In my SELECT Statement, I have to do this:

 

SELECT First Name FROM [Client Details$$];

 

I am getting the following error:

 

Syntax error (missing operator) in query expression 'First Name'.

 

How do I resolve this issue?

 

Thanks

    2 replies

    Tamil Arasu10
    Most Valuable Pathfinder
    Most Valuable Pathfinder
    November 16, 2021
    _Tamil_
    Cadet | Tier 2
    February 22, 2022

    You need to put the table column names in [ ]

     

    Try : SELECT [First Name] FROM [Client Details$$];