I need your help. I am unable to connect using a Native OLEDBMicrosoft Jet 4.0 OLEDB Provider.
I am receiving the following error message “Test connection failed because of an error in initializing provider.
Un recognized database format C:usersvishshDocumentsmydb.accdb”.
Please help me resolve the issue.
The possible reason is you are using MS Access 64bit version.
Hope this helps.
Hi Irene_Plummer,
Firstly, you should download & install OLEDB Provider for Microsoft Office 12.0 Access Database Engine from here: http://www.microsoft.com/en-us/download/details.aspx?id=23734.
Now open SQL Server Management Studio and connect to the desired instance of SQL Server database engine. From the desired database, right click on “tasks” & then select “import data”. Follow on-screen instructions carefuly & select the Data source.
That should solve the problem.
