exporting data from ms access to ms project

[Rob Mcc]

Im wondering if any on can help me to export data out of an ms access
database into ms project 2002. I want to export a start date and
completion data of different projects, which is stored in the
database. I think this process can be done invisible to the user, so
that when they enter the data into access and save it, it will
automatically create a project schedule in ms project, which they can
refer to at a later date in the application. I would appreciate if any
one can give me any advice on this matter, i.e. VBA code etc or good
web sites etc that may be of use.

Regards Rob McC, England

[Tom van Stiphout]

On 17 Nov 2003 01:43:40 -0800, ro**********@fsmail.net (Rob Mcc)
wrote:

MsProject can use MsAccess (better: Jet) as its data store. That's not
the default, but you can configure it that way.
After that, your issue simply becomes a matter of attaching to the
right tables and appending some records.

Alternatively you may want to look into Automation to talk to the
MsProject object model, and use its methods etc to modify the data
store (whether native or MsAccess).

-Tom.

Im wondering if any on can help me to export data out of an ms access
database into ms project 2002. I want to export a start date and
completion data of different projects, which is stored in the
database. I think this process can be done invisible to the user, so
that when they enter the data into access and save it, it will
automatically create a project schedule in ms project, which they can
refer to at a later date in the application. I would appreciate if any
one can give me any advice on this matter, i.e. VBA code etc or good
web sites etc that may be of use.

Regards Rob McC, England

[TC]

Automation may be a better idea (as the other respondent said).
Alternatively, I know that I have seen a Microsoft document describing the
Project db schema. I just can't remember where. Some googling should be able
to find it.

HTH,
TC
"Rob Mcc" <ro**********@fsmail.net> wrote in message
news:4d**************************@posting.google.c om...

Im wondering if any on can help me to export data out of an ms access
database into ms project 2002. I want to export a start date and
completion data of different projects, which is stored in the
database. I think this process can be done invisible to the user, so
that when they enter the data into access and save it, it will
automatically create a project schedule in ms project, which they can
refer to at a later date in the application. I would appreciate if any
one can give me any advice on this matter, i.e. VBA code etc or good
web sites etc that may be of use.

Regards Rob McC, England