Delete a row from Excel via ADO.NET

[Jan Lorenz]

Hi,

I have a ADO.NET - Connection to an Excel file. UPDATE and INSERT works
fine. Now I want to DELETE lines, but it doesn't works (I get an error
message). Microsoft says, that there is no way to to this.
Knows anybody a way?

best regards
Jan

 

[Nicholas Paldino [.NET/C# MVP]]

Jan,

Where does Microsoft say this? The reason is most likely that there is
no primary key information that you can use to accurately identify rows in
the sheet (you could try and do a field by field match, but that's highly
unlikely).

What you might want to do is use automation to do this, and delete the
row manually.

Hope this helps.

 

[Jan Lorenz]

Hi,

I have a primary key. But I got the following error message: "Deleting data
in a linked table is not supported by this ISAM."
I have found it under
http://support.microsoft.com/?scid=kb;en-us;257819&x=7&y=11

The reason because I want to to this is, that I want to synchronize some
data of our customer database with this excel file.

Jan

Jan,

Where does Microsoft say this? The reason is most likely that there is
no primary key information that you can use to accurately identify rows in
the sheet (you could try and do a field by field match, but that's highly
unlikely).

What you might want to do is use automation to do this, and delete the
row manually.

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Hi,

I have a ADO.NET - Connection to an Excel file. UPDATE and INSERT works
fine. Now I want to DELETE lines, but it doesn't works (I get an error
message). Microsoft says, that there is no way to to this.
Knows anybody a way?

best regards
Jan