October 23, 2014 at 7:00 am
I'm trying to import an Excel (.xlsx, MS office 2010) spreadsheet in to my SQL (2K5) database. When I used the Openrowset('Microsoft.ACE.OLEDB.12.0......) I receive " The OLE DB provider "Microsoft.Ace.OLEDB.12.0" has not been registered" is it because the Jet MS OLEDB.4.0 is not loaded on the server, but it is loaded on my client machine? Is that also why it won't work via the Import Wizard.
October 23, 2014 at 12:52 pm
You need to install AccessDatabaseEngine.
it is a small Microsoft patch.
October 24, 2014 at 2:13 am
kd11 (10/23/2014)
I'm trying to import an Excel (.xlsx, MS office 2010) spreadsheet in to my SQL (2K5) database. When I used the Openrowset('Microsoft.ACE.OLEDB.12.0......) I receive " The OLE DB provider "Microsoft.Ace.OLEDB.12.0" has not been registered" is it because the Jet MS OLEDB.4.0 is not loaded on the server, but it is loaded on my client machine? Is that also why it won't work via the Import Wizard.
JET and ACE OLE DB are two different providers. You can download the ACE OLE DB provider here. There is also a 64-bit version available.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply