ODBC DSN working in ODBC test and Access, but not Excel

James Poole 1 Reputation point
2022-09-15T10:16:21.517+00:00

Hi,

I have numerous DSNs for connecting to data sources, without issue. However, I have two which test fine in the ODBC64 Source Administrator and MS Access but when I try to use it excel I get a password failure. I am 100% the username an password are correct, and have cleared them and retried multiple times.

Any clues?

Cheers

J

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,706 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.