Hi All,

Im working on VS app which fetches data from excel sheet and its working really well but the problem is now i want to update the excel sheet using code....! Im using this code


objConn.Open()
sql = "Insert into [Data$] (Projectc, Projectn, Customer, Endu, Projectm) values ('asdasd','asda','kjljkl','wqe','sdsadxc')"

Dim objCommand As New OleDb.OleDbCommand(sql, objConn)
Dim objAdapter As New OleDb.OleDbDataAdapter(objCommand)
objCommand.CommandText = sql
objCommand.ExecuteNonQuery()
objConn.Close()

But it is not accepting the column names... so please help me out...!

Ahmed Muneeb
Cell No. +93-321-6218648

(Your post’s subject line should be something like "Can't Update Excel with OLEDB" so that people know something about . . . well . . . the subject. Everyone posting a question wants help, after all... Just a tip.)

Do you wind up with an error (if so, what is the error message, and on which line does it occur), or does the program just silently do nothing?