Question

Excel file as a DB - SELECT Statement

  • 15 November 2021
  • 2 replies
  • 171 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

Userlevel 6
Badge +15

Hi @Nexus Music​ ,

 

Please find the below link,

 

Select * from [Sheet1];

 

https://developer.automationanywhere.com/blog/quicktip-connect-to-an-excel-spreadsheet-as-a-database/p>

 

 

You need to put the table column names in [ ]

 

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

Reply