Syntax error in Insert into statement while inserting data in excel sheet

Question

I am importing excel sheet at runtime in my windows forms, adding some data into it through form. When I am inserting that data back it's giving:

syntax error in insert into statement

This is the query I'm using:

string qry = string.Format("Insert into [Sheet1$] (username,password) values('"+uname+"','"+pwd+"')");

Just a hynch, but does your data have a single quote in either uname or pwd? — JohnFx
– JohnFx, Commented Dec 19, 2012 at 4:16
check this link: csharp.net-informations.com/excel/csharp-excel-oledb-insert.htm hope this will help you.regards — BizApps
– BizApps, Commented Dec 19, 2012 at 4:18
Can you show more of your code? Specifically the connection string. Also, how is your Excel sheet structured? — Sid Holland
– Sid Holland, Commented Dec 19, 2012 at 5:20

sajanyamaha · Accepted Answer · 2012-12-19 04:20:33Z

3

Try this ie adding [] to columns :

string qry = string.Format("Insert into [Sheet1$] ([username],[password]) values('"+uname+"','"+pwd+"')");

also try without string.Format()

answered Dec 19, 2012 at 4:20

sajanyamaha

3,2063 gold badges32 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user1909204 · Accepted Answer · 2012-12-21 04:36:40Z

0

The code was correct,there were permission issues with the excel file that i was using I wasnt having full control on that excel,I changed the permissions and the code started working.

answered Dec 21, 2012 at 4:36

user1909204

451 gold badge3 silver badges6 bronze badges

1 Comment

user692942 Over a year ago

So how come you said the other answer worked?

Collectives™ on Stack Overflow

Syntax error in Insert into statement while inserting data in excel sheet

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related