oledbcommand excel insert syntax error

Question

   string strSQL = "INSERT INTO " + firstSheetName + "(Date, Market, Source, Commodity, Frequency, Price, Report_Type, MISC, Breeds, Age_Group, Gender, Grade) VALUES ('Beth', 'Hart','Beth', 'Hart','Beth', 'Hart','Beth', 'Hart','Beth', 'Hart','Beth')";

 OleDbCommand OleDbCommand = new OleDbCommand(strSQL, oconn);

   OleDbCommand.ExecuteNonQuery();

what might be the problem ?

Neil Knight · Accepted Answer · 2011-10-26 08:16:17Z

2

You need a space after "INSERT INTO " + firstSheetName + "(Date,

to

"INSERT INTO " + firstSheetName + " (Date,

Another thing that I have noticed is that you have 12 column values and only 11 data values. You'll need to add the 12th data value.

edited Oct 26, 2011 at 8:16

answered Oct 26, 2011 at 8:02

Neil Knight

48.8k26 gold badges136 silver badges193 bronze badges

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

6 Comments

maztt Over a year ago

no this also doesn't solves the problem . $ are allowed in the name?

Neil Knight Over a year ago

Change your query to "INSERT INTO [" + firstSheetName + "] (Date, etc.

Fionnuala Over a year ago

Surely INTO [" + firstSheetName + "$]

Neil Knight Over a year ago

@Remou: I'm under the impression that firstSheetName equals something like MySheet$

Fionnuala Over a year ago

Good point, but I suspect it does not. (I should have added an @ for the OP, because the comment was much more meant for @mazhar)

|

Collectives™ on Stack Overflow

oledbcommand excel insert syntax error

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related