ODBC excel driver login failed

By morecowbell ·
Hi Folks!

Receiving this error when trying to export contacts to an excel file.

ODBC excel driver login failed, The microsoft Jet database engine could not find the object '(unknown)'. Make sure the object exist and that you spell its name and the path correctly.

Any ideas

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Re: ODBC excel driver login failed

See if any of these help you.

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.

Collapse -

not a workbook issue

by morecowbell In reply to ODBC excel driver login f ...

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)

Collapse -

more info

by morecowbell In reply to ODBC excel driver login f ...

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

Related Discussions

Related Forums