ODBC in VBA

[Ruth]

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 Gill]

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.

 

[Ruth]

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