ODBC in VBA

I want to import data from a table/query in MS Access 2002 into MS
Project using an ODBC connection. I don't know if the .connection
method is appropriate or how to use it. I would like some help on
understanding the method. I have successfully imported data using VBA
but that' s from an Excel spreadsheet as the intermediary and it's
brought in temporarily and erased at the end of allocating data to
tasks/assignments in project. All this was done in vba I just want to
make the connection streamless and get rid of the excel step. I don't
want to use the convert ms project into an access database unless I
have to.

Any help would be appreciated! Thanks in advance.

Rod
Fri Nov 18 02:59:45 CST 2005

There are plenty of examples in msdn.microsoft.com and elsewhere on using
ODBC to read data from Access or any database. I prefer using Oledb so I
don't need a DSN.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


"Ruth" <ruth@structurali.com> wrote in message
news:1132261169.652029.184780@g49g2000cwa.googlegroups.com...
>I want to import data from a table/query in MS Access 2002 into MS
> Project using an ODBC connection. I don't know if the .connection
> method is appropriate or how to use it. I would like some help on
> understanding the method. I have successfully imported data using VBA
> but that' s from an Excel spreadsheet as the intermediary and it's
> brought in temporarily and erased at the end of allocating data to
> tasks/assignments in project. All this was done in vba I just want to
> make the connection streamless and get rid of the excel step. I don't
> want to use the convert ms project into an access database unless I
> have to.
>
> Any help would be appreciated! Thanks in advance.
>

Ruth
Fri Nov 18 10:01:37 CST 2005

I didn't know there was a microsoft.public.project.developer's group.
I'll look there. Thanks for your help!