I had same experience as Krista Olson. You need 32-bit Microsoft Access Database engine 2010 to get it work. Not from the reason that excel files are 32-bit or 64-bit, the problem is in OS which is not 64-bit completely. For example if you schedule the job in Agent - Agent is running as a 32-bit process and cannot run any 64-bit dtsx package.