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 OleDbCommand

Dim 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.

[1644 byte] By [Donaghy] at [2007-12-25]
# 1

Sorted

Just needed to apply Read/Permissions for user, thought this was automatically set.

Donaghy at 2007-8-31 > top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...
# 2
This generally means that the user under which your code is executing does not have write permissions to the Excel file.
CommonGenius.com at 2007-8-31 > top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...

.NET Development

Site Classified