ODBC excel driver login failed

Clarifications

See if any of these help you.

WORKAROUND
Method 1:
Remove the Workbook Password
To work around this problem, remove the password from the workbook. To do this, follow these steps:
1. Start Microsoft Excel.
2. On the File menu, click Open.
3. Locate and select the workbook with the password.
4. Click Open.
5. Enter the password for the workbook and click OK.
6. On the File menu, click Save As.
7. Click the drop-down arrow next to Tools, and click General Options.
8. Delete the text in the Password to open box and click OK.
9. Click Save. Click Yes when you are prompted to replace the existing file with the same name.
10. Close the workbook.
You can create your data source without receiving an error message.

Method 2:
Open the File in Excel
If you have the password protected workbook open in Microsoft Excel, you will be able to successfully create a data source for this workbook. However, you must have this workbook open when you use this data source or when you refresh a query that is pulling data from this data source.

Please post back if you have any more problems or questions.
If this information is useful, please mark as helpful. Thanks.

It is not a work book issue.
I am simply trying to export my contacts in Outlook to an excel file and I am getting errors.
It is not finding the Outlook target file and gives me some weird ODBC error.

(qoute from user)

user receiving translation error ....with the ODBC excel driver login failed...