Insert Into .xls

[vjainpee]

I m new to c#

I m trying to retrive and insert data into EXCEL from asp.net,treatin g excel as a data source

while inserting i m facing problem because the names of columns in my .xls are having spaces in between , which are not
permitted in C#

this is my query
string CommandText = "INSERT INTO [Sheet1$] (Query No, Document) values ('111', 'ABC')";

and this is the error I m getting

Syntax error in INSERT INTO statement.

what to do ???????

Thanks in advance

[Curtis Rutland]

Put [brackets] around the column names (I think. that would work for a sql table, at least).

[r035198x]

Put [brackets] around the column names (I think. that would work for a sql table, at least).

If that doesn't work try quotes around the table name.