Re: ODBC Conenction Programmatically

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 12/30/04 

Date: Thu, 30 Dec 2004 12:08:33 -0500

Data=>Get External Data

or

Data => Import External Data

Depending on version of Excel. 

-- 
Regards,
Tom Ogilvy
"Todd Huttenstine" <anonymous@discussions.microsoft.com> wrote in message
news:050201c4ee8f$a9c1a230$a301280a@phx.gbl...
> 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" <anonymous@discussions.microsoft.com>
> wrote in message
> >news:12ae01c4ee8d$2987c6a0$a501280a@phx.gbl...
> >> 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
> >
> >
> >.
> >
Quantcast