I am not able to use insert query while using Execute Non Query on Excel

excel

#1

Hi All,

I am trying to execute a non query on an excel. it worked well on select and update query but it throwing following error when i start executing insert query.Could any one help me.

Please find the below details
"INSERT INTO [Sheet1$] ([Sheet1$].Sno) VALUES (‘2’)"

Error message
ACEODBC.DLL : ERROR [HYS22࠹] [Microsoft][ODBC Excel Driver] The INSERT INTO statement contains the following unknown field name: ‘Sheet1$.Sno’. Make sure you have typed the name correctly, and try the operation again.

I have given the exact name without any manual typing.

Regards
Prathap