Microsoft Data Link has encountered an error

Asked By 0 points N/A Posted on -
qa-featured

Hi,

I got this following weird error message when I attempted to import Microsoft Access 2007 format database (*.ACCBD) into SQL server. The error showed “Test Connection failed because of an error in initializing provider.

Could not find installable ISAM”. I have installed all the drivers properly but I can’t resolve this issue without having your assistance.

Please suggest me.

Thanks in advance.

Microsoft Data Link Error Test Connection failed because of an error in initializing provider. Could not find installable ISAM.

Microsoft Data Link Error

Test Connection failed because of an error in initializing provider. Could not find installable ISAM.

SHARE
Answered By 0 points N/A #176090

Microsoft Data Link has encountered an error

qa-featured

Hi John,
The error is because of difference between database engine of Microsoft Access 2007 and SQL Server.
The solution to it is:
1) Install the OLE DB Provider for Microsoft Office 12.0 Access Database Engine
2) After installation, go to 'SQL Server Import and Export wizard'
3) In the Data Source tab, select 'Microsoft Office 12.0 Access Database Engine OLE DB Provider'

SQLServer-ImportExport-Wizard-for-Data-Source

4) Import data into SQL Server
5) Extract the required result by using SQL statements

Login/Register to Answer

Related Questions