ODBC Error: Data Source name Not Found and No Default Driver Specified

A

Alex

Hi everyone,
When trying to query a SQL database via Excel and when
trying to refresh the information within Excel, I receive
the following error:

ODBC DRIVER MANAGER: Data Source Name Not Found and no
Default Driver Specified.


Does anyone know what this is and how to fix this?
Thank You!
 
T

Tushar Mehta

[This followup was posted to microsoft.public.excel.misc and a copy was
sent to the cited author.]

In addition to Rich Wallach's suggestion, consider using MS Query to
create a query (Data | Get External Data > New database query...). Once
done, check the SQL syntax in MS Query itself. That should give you
necessary database access/file name constructs.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC Issue with Pivot Table 1
odbc error on Excel query into database 2
ODBC PivotTable Error 1
Excel ODBC driver created table/data not persistent 2
Import external data problem 1
Error: Microsoft ODBC Driver Manager Data Source name not found 0
ODBC Error Message 1
Microsoft ODBC Drive Manager: Data Source Name not found and No Default Driver Specified 3

Top