ashok kumar

ashok kumar

  • NA
  • 89
  • 36.2k

Unable to insert into Excel file Using C#

Sep 16 2014 6:37 AM
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 

Answers (2)