export from msaccess to msproject

[gobble]

I have been asked to interface our database in MSAccess with MS Project. So that certain fields can be exporting to MS Project to produce plans for workloads etc However I am finding it difficult to find any code or information as to how I could do this. Could someone help or point me in the right direction?

Thanks

Juls

 

[jebry]

Hi Juls!

A couple of possibilities:

1.) Assuming you have Project installed on your computer you should be able to set a reference to it. Do this in your code window by selecting Tools/References and finding Microsoft Project. Then you will be able to find some information in the Object Browser about the objects/properties/methods availble.

2.) If Project allows you to record macros (I have never used Project so I don't know if it does or not) then you can record a macro doing what you want to do from Access. Then you go to that macro and choose to edit it. This will take you to the VBA window with the code Project wrote to accomplish the task. This will be the same code you need to use in Access.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[joshuar]

Juls,

When I did this ~10 years ago, we exported about 5 tables from Project, imported them into Access, made the changes in Access, exported from Access and imported into Project. It has been years since I've used Project, but you should still be able to export the data from Project and link to it. Unfortunately, I no longer have the specs for each table, but you might be able to find them in the Project documentation.

-Joshua

 

[jdrea]

Juls,

We currently use ODBC to save our MSProject files directly to MSAccess tables. Once the information is there it can be edited either through MSAccess or MSProject.

Exactly how your process works depends on where the information is originated (Project or Access). We create files (mpp) in MSProject, send them to MSAccess tables, and edit them from either application. Although, once the MSAccess database is set up for MSProject files you can create new projects, tasks, etc from MSAccess.

Jim