I am having difficulty updating an Excel worksheet via the ACE.OLEDB.12.0
I have a worksheet defined as a linked server in SQL Server via this
provider, and all attempts to update the lone worksheet in this file as a
linked server results in the following:
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "linked_excel"
returned message "Bookmark is invalid.".
Msg 7346, Level 16, State 2, Line 1
Cannot get the data of the row from the OLE DB provider
"Microsoft.ACE.OLEDB.12.0" for linked server "linked_excel".
update linked_excel...sheet1$ set error_col='hithere' where
However, when I try to perform precisely the same update against the same
source via openrowset, it works, to-wit:
12.0;HDR=yes;Database=f:\path_to_file\filename.xlsx','select * from
SELECT's performed against either version work properly.
The linked server behavior is consistent across SQL 2005 and 2008
I am concerned that this problem is an artifact of an OLEDB provider update that purposely disabled update b
View Complete Post