'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine'

508 Views Asked by At

I am trying to migrate my existing Access2007 database to sql server 2008. Installed SSMA for that purpose. Everything goes fine until it starts migrating the data. I get an error Establishing connection with the source database failed. The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine..

I already searched for all possible solution to my problem. Even after installing AccessDatabaseEngine for Access2007 from `http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734 , still not migrating data. Here's a snap shot of it. enter image description here
Please help me.

Note: Using Access2007,SqlServer 2008,OS Win8.1

0

There are 0 best solutions below