Execute Non Query: ERROR [42000] [Microsoft][ODBC Excel Driver] Cannot modify the design of table 'TableName'. It is in a read-only database. in uipath

Help Activities
, ,
1

Hi,

I am connecting .xlsx file as db and using alter table query.
But I am getting Execute Non Query: ERROR [42000] [Microsoft][ODBC Excel Driver] Cannot modify the design of table ‘Denton$’. It is in a read-only database. in uipath error.

I referred Execute query : Cannot modify the design of table ‘table_name’. It is in a read-only database and
I tried to include .xlsx after tablename but I am not sure how to add .xlsx in the query after table name. Can anyone help me in this?

Thanks,
Maha

2

Hi @MahaLakshmi_Natarajan ,

Didnt understand your problem. Show the screenshot or some sample.