Accessing MS Project from MS Access

[mba1976]

Hi there,

How do I get MS Project data from MS Access?

I notice that from MS Project you can use the Save As feature to save as MS
Access. Is there another way to transfer MS project data to MS Access from MS
Access?

And when MS Project data are in MS Access, is there a way to communicate
with MS Project data from MS Access, such as adding Resources name and Task
name in MS Access that will also update in MS Project?

Thanks in advance,

mba1976

 

[Guidho]

You can do this by creating a macro or a com-addin.

From within VBA for MS Project you can access any Office application,
including Access.

And using Office interoperability you can create a COM addin which
allows Project to talk with Access.

Guidho

 

[Rod Gill]

By saving a project in Access using File, Save as, you can read and use the
prjdb.htm file (in one of Project's program folders) to add more resources,
tasks and assignments that Project will recognize when it next opens the
project. Without doing this, you have 2 ways:
1) Use VBA to import and export data
2) Use File, Save as and File, Open with file type .mdb then create a Map in
the import or export Wizard to select the fields you want.

--

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

NEW!! Project VBA Book now in stock, for details visit:
www.projectvbabook.com

 

[mba1976]

Hi Guidho,

Thank you very much for your reply.

Do you have an Macro or com-addin example that import project Data into MS
Access?

Also, I am not familier with interoperability. Where I can get more info or
example.

Thanks,
mba1976

 

[Gary L. Chefetz [MVP]]

MBA:

You might want to consider picking up Rod Gill's new Project VBA book. Rod
provides code samples that will get you up an running quickly. Guaranteed to
save you a couple day's work. See the link in my signature line for more
information or search "Rod Gill" on Amazon.

 

[Guidho]

Im sorry, I don't have any code sample available that will import data
from access into MS Project.

You might want to look for code samples on the internet. As there are
not to much code samples available for MS Project, just search for a
code sample to import data from Access into Excel.

This is very similar to how to do it in project.

Guidho