Update Excel Data
I have connected to and display data from an excel spreadsheet, though i can't seem to update the excel data.
I get the following error "Operation must use an updateable query"when i try to update the excel data with the following code:
Dim sConnectionStringAsString = "Provider=Microsoft.Jet.OLEDB.4.0;" _& "Data Source=" & Server.MapPath("../FSE_VB/FSE_Mock.xls") _
& ";" & "Extended Properties=Excel 8.0;"
Dim objConnAsNew OleDbConnection(sConnectionString)
objConn.Open()
Dim objCmdSelectAsNew OleDbCommandDim cmdAsNew System.Data.OleDb.OleDbCommand("UPDATE [FSE$] Set Name = 'Steven Donaghy' Where Name = 'Paul Donaghy'", objConn)cmd.ExecuteNonQuery()
objConn.Close()
Any ideas why i would be getting this error, also how to fix, thanks.

