Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am using VS2012 and creating a package on a 64bit machine to import some data from a .xlsx file. My question is that I am getting an error for the Excel connection manager, do I need to install some kind of excel drive or excel itself on the machine in order to be able to import the data?

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

Thanks

share|improve this question
add comment

2 Answers 2

You'll need to configure SSIS to run in 32-bit runtime as Excel does not support 64-bit

Go to the Property page for the Solution, select Debugging and change Run64BitRuntime to False

Running 32-bit SSIS in a 64-bit Environment

share|improve this answer
add comment

I have actually fixed this now by installing the 32-bit ACE OLE DB provider

Thanks

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.