Access 2010 Import Spreadsheet Wizard

[frdebelo]

I get the error message;

The Wizard is unable to access information in the file c:\Data... Please check that the file exists and is in the correct format..

The Excel file I am trying to import has a password but Access does not offer the option to input the password to allow the Excel file to be imported.

In Access 2007, the same files, Access would ask for the password to allow the import to proceed.

All of my Excel files are password protected. I have to remove the password on the file, import into Access, the replace the password in the Excel file.

Is this a security setting in Access I can change, or is there another answer????



Frank.

[June7]

Sounds like a 2010 bug and another reason I won't recommend our office move up to 2010.