Direct Link from MS Project to MS Access

[Ben]

I'm building a database in MS Access. The source of the information
is MS Project. Right now we are exporting project information from MS
Project into Excel, and I'm importing into Access.

Is there a way to link Access tables directly to Project tables to
pull information, so updates occcur automatically and no export/import
is needed?

 

[Jim Aksel]

You can save the Project File (mpp) as a Microsoft Access Database (mdb).
Files/Save As...
The resultant file can be linked to another Access Database in the usual
manner.
Also, when you go back to MS Project, you can select File/Open and then
specify Access Database as a file type.

When you select the Access Database that was originally sourced in Project,
you can open the file into MS Project with no problems. Caution, Linking and
Importing are two different things. If you link, then changes you make in
your Access Database will propagate to the Project Access Databse and become
visible when you open Project.

Also, there may be startling architectural differences between your existing
Access Database and the Access Database from MS Project. However, once you
understand the architecture, things will run smoothly.

If you fould this post helpful, please consider rating it.
Thanks

 

[rt]

Hi Jim, I never noticed you can save an MPP as MDB, thanks for that
info. My only question is why one would want to do this, as all
information is already in a SQL database?

 

[Jan De Messemaeker]

Hi,

When you do not use Project Server, Project saves in its own format (mpp)
and not in SQL server;
HTH

 

[geoff pratt]

Hi Jim,
Using Project 2007 (Std), there is no option to save as an Access database
in the dropdown; however, there is an option to open Access files.
So how do you get them there in the first place?

Thanks........Pratta

 

[Dale Howard [MVP]]

Geoff --

In the future, please post your Project Server questions in the
microsoft.public.project.server newsgroup, as this newsgroup is closing
down. To answer your question:

1. Using an earlier version of Microsoft Project (2003 or older), save a
project to an Access database.
2. Create a project file in the Access database using Microsoft Access
directly.

Hope this helps.