Sunday, September 11, 2016

Could not retrieve the table information for the connection manager Excel Connection Manager

You may experience the below error if you try to connect with latest version of Microsoft Excel using Integration Services;

Could not retrieve the table information for the connection manager 'Excel Connection Manager'. Failed to connect to the source using the connection manager 'Excel Connection Manager'


This error comes when you try to retrieve Excel Sheets from the connected Excel Workbook. In order to solve this, you need to install correct OLE DB Providers and Drivers for Microsoft Office files. Follow the link below for downloading the correct version;


Note that if you have 32-bit version of Office, then you need 32-bit drivers else you need 64-bit drivers.

2 comments:

Daniel Melo said...

Hi Dinesh,

Thanks for your post. I have Windows 10 64bits. I downloaded and installed the driver but still doesn't work. When I choose the connection manager type for excel, the file name is: C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\
Should I change the path of the file name to C:\Program Files\Microsoft SQL Server\120\DTS\Binn.

Thanks in advance

Dinesh Priyankara said...

Hi Daniel,

I believe that you have installed 64-bit driver that is correct. However, since VS is a 32-bit application, install 32-bit driver too, it might solve the issue, let me know how it goes.

Regards
Dinesh