Adding column using Alter statement in Excel as a Database

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)”
its showing error as .

please help.

You should use Execute Non Query :
Also, check if the statement is written correctly.

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

Able to find the solution for this topic?