Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I use SQL Server linked servers to connect to Excel 2003 multiple tabs workbook. After connected, I have not problem to use select statement like:

select * FROM OPENQUERY(TEST, 'select * from [fist day$]')

but I can not use normal delete and insert statement. I want to delete data from first row and insert one row of data into the last row to the excel spreadsheet.

I use:

delete top(1) FROM OPENQUERY(TEST, 'select * from [first day$]') 

and I get

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TEST" returned message "Deleting data in a linked table is not supported by this ISAM.".
Msg 7345, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TEST" could not delete from table "select * from [first day$]". There was a recoverable, provider-specific error, such as an RPC failure.

share|improve this question
Is this referring to the same issue as you've asked about here(…) – ConcernedOfTunbridgeWells Feb 15 '12 at 16:25

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.