Microsoft Data Link has encountered an error

Asked By John W Griggs 0 points N/A Posted on - 07/27/2013

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.

• Status: Open
• Question Views: 1118
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Microsoft Others

Answered By Patrick S Garcia 0 points N/A #176090

Microsoft Data Link has encountered an error

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’

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

About Patrick S Garcia

Questions
5

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/30/2013
• Question Category: Microsoft Others