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’)”
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.