July 18, 2005 at 9:31 am
Hi I have set up a linked server to an excle spreadsheet, from which I have been running a number of queries. However I would like to delete rows from the sheet.
I wrote created the following
DELETE [EXCELServer]...[CPFormData_SWE$]
FROM [EXCELServer]...[CPFormData_SWE$] spreadsheet
INNER JOIN ga_level ON ga_level.level_no = spreadsheet.[level number]
WHERE (spreadsheet.[REGISTRATION DATE] IS NULL AND ga_level.original_reg_dt IS NULL)
OR (spreadsheet.[DATE FORMED] IS NULL AND ga_level.formed_dt IS NULL )
When I run it however, I receive the following error
Server: Msg 7301, Level 16, State 2, Line 4
Could not obtain a required interface from OLE DB provider 'Microsoft.Jet.OLEDB.4.0'.
July 18, 2005 at 4:39 pm
I don't think Excel driver allows for rows to be deleted from it - see http://support.microsoft.com/default.aspx?scid=kb;EN-US;257819
James Horsley
Workflow Consulting Limited
July 19, 2005 at 12:38 pm
Thanks James, I had suspected as much - A shame really 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply