I want export data from MSSQL SERVER 2008 from Excel, but i have error
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"
returned message "Bookmark is invalid.".
Msg 7343, Level 16, State 2, Line 1
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"
could not INSERT INTO table "[Microsoft.ACE.OLEDB.12.0]".
its my excel file on export (file save in format 97-2003)
![Excel file version 97-2003 on server](https://i.stack.imgur.com/STsP0.png)
its my query
![SQL QUERY](https://i.stack.imgur.com/bNFAH.png)
Tell me please why i get errors? What me need doing?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…