Unable to insert into Excel file Using C#

Question

Hi All iam facing an issue iam able to insert values into my excel file using c# successfully .but when my column name contains # ex Target_Group# iam getting error unknown column name but in my excel the column name is there Target_Group#  pls find my insert Query string query = INSERT INTO [Sheet2$] ([Target_Group#]) VALUES('OHMCRWP0'); iam using oledb connections pls help me out on this

Ramesh Maruthi · Answer

Hey Ashok try { System.Data.OleDb.OleDbConnection MyConnection ; System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand(); string sql = null; MyConnection = new System.Data.OleDb.OleDbConnection(provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\csharp.net-informations.xls';Extended Properties=Excel 8.0;); MyConnection.Open(); myCommand.Connection = MyConnection; sql = INSERT INTO [Sheet2$] ([Target_Group#]) VALUES('OHMCRWP0'); myCommand.CommandText = sql; myCommand.ExecuteNonQuery(); MyConnection.Close(); } catch (Exception ex) { MessageBox.Show (ex.ToString()); } Errors may occur due to : Test your database connection in the server explorer make sure it succeeds and then try it. Usually in these scenarios the database connection may not be connected properly.

Wim Sturkenboom · Answer

Maybe it works if you embed Target_Group# in double quotes? string query = INSERT INTO [Sheet2$] ([ \ Target_Group# \ ]) VALUES('OHMCRWP0') Not sure though.