Skip to main content
Question

Excel file as a DB - SELECT Statement

  • November 15, 2021
  • 2 replies
  • 415 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+18
  • Most Valuable Pathfinder
  • November 16, 2021

  • Cadet | Tier 2
  • February 22, 2022

You need to put the table column names in [ ]

 

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