I don't know if this makes a difference but I was able to suck in an Excel document using SQL 2008 R2's import wizard (OS is Win7 64 Bit) and I had it create a package on the file system. Since the Import Wizard was successful, I decided to create an SSIS solution and added the package that was created by the wizard to that solution in Business Intelligence Studio. When I ran that package from inside the BI IDE it failed with the error "The Microsoft ACE.OLEDB.12.0 provider is not registered on the local machine" and stating that the 64 bit driver may not be installed. I wondered then how the SQL Server Import wizard was able to get it to work but not in SSIS. Well I ended up clicking the menu option Project, Properties, then in the dialog box under Configuration Properties, Debugging, Debug Options, I set the option Run64BitRuntime to false. Then when I executed from BI, it ran fine.