Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Microsoft Office 12.0 Access Database Engine OLE DB Provider missing from SQL Server 2008 R2?

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?

like image 735
user1929393 Avatar asked Jul 01 '14 18:07

user1929393


People also ask

Where is Microsoft Access database engine installed?

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.


1 Answers

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

like image 155
user1929393 Avatar answered Oct 15 '22 01:10

user1929393