SSIS and Excel import 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
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