Operation must use an updateable query EXCEPTION when trying to update excel

[Muskito]

HELP!!!

Hello All,

I'm using VB.net 2003 and trying to update data in Excel worksheet.

The program selects data from the excel, updates something in the MSSQL
DB and then tries to update something back to the excel worksheet.

My problem is that i'm having this annoying exception: "Operation must
use an updateable query"
1. The excel worksheet is on the desktop
2. The file has full permission for Everyone
3. The Folder has full permission for Everyone

The code looks like this:

Dim oConnection As System.Data.Ole Db.OleDbConnect ion
oConnection = New System.Data.Ole Db.OleDbConnect ion( _
"provider=Micro soft.Jet.OLEDB. 4.0; " & _
"data source=" & txtFile.Value & ";" & _
"Extended Properties='Exc el 8.0;IMEX=1'")
oConnection.Ope n()
Dim sCmd As String = "UPDATE [" & txtSheetName.Va lue & "$] SET " &
dsExcel.Tables( 0).Columns(13). ColumnName & " = '" &
oRow.ClientNumb erInServiceGive r & "' WHERE F8 = '1549461305'"
Dim oCommand As New OleDb.OleDbComm and(sCmd)
oCommand.Connec tion = oConnection
oConnection.Ope n()
oCommand.Execut eNonQuery()

the sCmd looks like this when it is running:
"UPDATE [Sheet1$] SET F14 = '7370037530-3' WHERE F8 = '1549461305'"

Does anyone have any idea for why this problem occurs?...

Thanks in advance.

[tomb]

I had this same issue a while back in Access with a linked Excel file.
The damn thing isn't updateable! I don't understand it. Never found a
way to update it, either. I had to build a new spreadsheet with the
new data.

T

Muskito wrote:

HELP!!!

Hello All,

I'm using VB.net 2003 and trying to update data in Excel worksheet.

The program selects data from the excel, updates something in the MSSQL
DB and then tries to update something back to the excel worksheet.

My problem is that i'm having this annoying exception: "Operation must
use an updateable query"
1. The excel worksheet is on the desktop
2. The file has full permission for Everyone
3. The Folder has full permission for Everyone

The code looks like this:

Dim oConnection As System.Data.Ole Db.OleDbConnect ion
oConnection = New System.Data.Ole Db.OleDbConnect ion( _
"provider=Micro soft.Jet.OLEDB. 4.0; " & _
"data source=" & txtFile.Value & ";" & _
"Extended Properties='Exc el 8.0;IMEX=1'")
oConnection.Op en()
Dim sCmd As String = "UPDATE [" & txtSheetName.Va lue & "$] SET " &
dsExcel.Tables (0).Columns(13) .ColumnName & " = '" &
oRow.ClientNum berInServiceGiv er & "' WHERE F8 = '1549461305'"
Dim oCommand As New OleDb.OleDbComm and(sCmd)
oCommand.Conne ction = oConnection
oConnection.Op en()
oCommand.Execu teNonQuery()

the sCmd looks like this when it is running:
"UPDATE [Sheet1$] SET F14 = '7370037530-3' WHERE F8 = '1549461305'"

Does anyone have any idea for why this problem occurs?...

Thanks in advance.