Data=Get External Data

or

Data = Import External Data

Depending on version of Excel.

--
Regards,
Tom Ogilvy



"Todd Huttenstine" wrote in message
...
How can you access the ODBC manager from within Excel? I
dont think you can...


-----Original Message-----
Turn on the macro recorder and do it manually. Then turn
it off and look at
the code.

--
Regards,
Tom Ogilvy

"Todd Huttenstine"
wrote in message
...
Hey guys

Using ODBC, it is possible to set up a connection to a
database. Instead of having to do this manually for
multiple computers, I would like to be able to run a
code
that will do it automatically. For instance if I wanted
to setup a database connection to file C:\test.mdb, I
would open up the ODBC managaer and then type in a
description, navigate to the source, etc.. How do I
write
code that will set up a system database connection to a
file called test.mdb located on C:\?


Thanks
Todd Huttenstine


.