Remove the 64 Bit driver and install the 32 bit one. Visual Studio 2010 is a 32 Bit application therefore it cannot operate on 64 Bit drivers.Arthur My Blog

Hi Mike, Please follow the below link. I hope it will help. http://36chambers.wordpress.com/2010/07/13/ssis-and-excel-on-a-64-bit-server/ Thanks, Madhava

Thanks, it's helped a little, but now the error message says the file is not in the expected format.

Uninstalled the 64 bit driver. When I attempt to install the 32 bit driver, the install fails because I have 64-bit Microsoft Office Professional Plus 2010 installed. Does this mean I have to uninstall all my office products?

Yes,Remove the 64Bit Office edition because it brings with it the 64 Bit driver that is incompatible with its 32 Bit counterpartArthur My Blog

That got it done, thanks for your help.

I recently upgraded to a new laptop running Windows 7 64 bit (which my previous laptop was as well). I'm having trouble accessing SSIS packages I originally wrote on the previous laptop. Both used Visual Studio 2010 with no problem, but I fear something wasn't loaded. The package in question uses an Excel 2010 file as the source for a data flow step. When I open the Excel source and select "Columns", it tells me "the requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered". It won't even let me look at the step, let alone run it. Reading up on the issue, I figured I needed Microsoft Access Database Engine 2010 for 64-bit windows. I loaded it, and it shows up in the Programs list. But I'm still getting the same error. Is there another driver I need, or do I need to point Visual Studio to this driver?

In BIDS or SSDT, right click on your project, go to project properties and set Run64BitRuntime to false. here you can read more about problems that you may face with 64bit environment with SSIS: http://toddmcdermid.blogspot.co.nz/2009/10/quick-reference-ssis-in-32-and-64-bits.htmlhttp://www.rad.pasfu.com

Tried that, still the same issue

Remove the 64 Bit driver and install the 32 bit one. Visual Studio 2010 is a 32 Bit application therefore it cannot operate on 64 Bit drivers.Arthur My Blog