Unable to insert into Excel file Using C#

ashok kumar

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Maruthi12y ago
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.

0
Wim Sturkenboom12y ago
Maybe it works if you embed Target_Group# in double quotes?

string query = "INSERT INTO [Sheet2$] ([\"Target_Group#\"]) VALUES('OHMCRWP0')"

Not sure though.
0