I'm trying to import an .accdb
MS Access database into SQL Server 2008 R2, but cannot find the Microsoft Office 12.0 Access Database Engine OLE DB Provider in the provider list for both the import wizard, and the SSIS. Tried both and not there.
I downloaded and installed MS Access Database Engine 2010, and MS Access Engine 2013, but still not there. How to add this so it will show up in SQL Server 2008 R2?
To check whether the 32-bit Microsoft Access Database Engine drivers are installed, go to C:\Windows\SysWOW64\odbcad32.exe. If on a 32-bit machine, go to C:\Windows\System32\odbcad32.exe to access the utility.
Solution :
Download 2007 Office System Driver: Data Connectivity Components from here: http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734
Download Microsoft Access Database Engine 2010 Redistributable from here: http://www.microsoft.com/en-us/download/details.aspx?id=13255
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With