Export Information From MS Access to MS Project

[Guest]

Good Afternoon,
I am looking at simplifying the process of project management, by exporting
information held on our database to Microsoft Project, and more specifically
the Gantt chart. Could anyone recommend where i can find a good step by step
guide? I've tried googling to no avail.
I use MS Access 2002 and operate on Windows XP.

Many Thanks
Dave

 

[pietlinden]

Good Afternoon,
I am looking at simplifying the process of project management, by exporting
information held on our database to Microsoft Project, and more specifically
the Gantt chart. Could anyone recommend where i can find a good step by step
guide? I've tried googling to no avail.
I use MS Access 2002 and operate on Windows XP.

Many Thanks
Dave

There is a code sample in Scott Barker's Access 2000 Power Programming
where he does exactly what you describe. It's in the Automation
chapter. Other than that, either dig around this NG or check the MS
website.

 

[Guest]

Dave - I'm attempting the same process. I took an existing project and
exported to an XLS format. I then viewed the excel file to understand the
format project was expecting. I made a make-table query in Access to mimic
the format and then exported the table to XLS - and imported it to Project.

I created a macro in Access to automate the process and created a shortcut
on my desktop to simplify execution.

I'm up to getting project to import the XLS file automatically when it
starts up.

-Swark