Skip to main content
Question

Excel file as a DB - SELECT Statement

  • November 15, 2021
  • 2 replies
  • 313 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
Forum|alt.badge.img+16
  • Most Valuable Pathfinder
  • 3274 replies
  • November 16, 2021

You need to put the table column names in [ ]

 

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings