I was able to set this up successfully on my local and on production, as long as the user credentials used on running the script is a sysad.
This url (http://www.excel-sql-server.com/excel-import-to-sql-server-using-distributed-queries.htm) By Sergey Vaselenko was very helpful
It's been up and running for months already. And just all of a sudden, sometime around last week, I received a complaint from one of our users who utilizes the uploader that they can no longer upload any excel files.
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"
returned message "Unspecified error". Msg 7303, Level 16, State 1,
Line 1 Cannot initialize the data source object of OLE DB provider
"Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
No one is altering the script.
No one has updated the server nor my local.
All of the servers for different apps that uses the script encountered the error.
I can't even run it on my own local pc.(When I use JET as a driver on my local it still works, but can't run it using ACE driver)
I'm really confused already on what happened on the ace driver?
I'm starting to wonder if there have been any update backend from microsoft or some kind of a bug on the ace driver??
Hope someone could help me if you have similar issue.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…