Adding column using Alter statement in Excel as a Database

Help
, , ,
1

Hi All,

I am doing a Automation where I am using Excel as a database.
I have to add a column in Excel Database.
so for that I am using Alter statement.
“Alter table [table_name$] add column_name varchar(100)”
image
its showing error as .
image

please help.

2

You should use Execute Non Query : https://docs.uipath.com/activities/docs/execute-non-query
Also, check if the statement is written correctly.

3

execute non query is also not working
I think there is a problem with the query.

4

Able to find the solution for this topic?