Linking Access 2007 to Microsoft Project 2007

[Dale Fye]

I have an application that tracks various projects with milestones and other
dates. My client is interested in visually depicting some of this
information, and would like to try using Microsoft Project.

They have created a small Project file with data they extracted and manually
entered into project. What we now want to do is figure out how to either
link Project to Access to use the Access tables directly, or to use Access to
identify "differences" between their data and what exists in the application.

Does anyone have any experience in this area?

What is the format of a "Project" file.

Anything I should know before I go blindly stumbling into this?

 

[JohnR]

A few years back, I created an Access Application that took data from an
Access Dataabase and made entries/updates to a Microsoft Project. I started
by learning the Project Object Model. Here is a link to it.

http://msdn.microsoft.com/en-us/library/bb179353.aspx

 

[Rod Gill]

Unless your Access database is structured exactly as Project needs it then
the only way to read data from any database in Project 2007 onwards is using
VBA code, either in Access to push data to Project or in Project to pull
data from Access. Project 2003 and earlier does have an ODBC link and you
can create a map to map fields in Access to fields in Project. This does not
link data, but does import to Project.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

I have an application that tracks various projects with milestones and
other
dates. My client is interested in visually depicting some of this
information, and would like to try using Microsoft Project.

They have created a small Project file with data they extracted and
manually
entered into project. What we now want to do is figure out how to either
link Project to Access to use the Access tables directly, or to use Access
to
identify "differences" between their data and what exists in the
application.

Does anyone have any experience in this area?

What is the format of a "Project" file.

Anything I should know before I go blindly stumbling into this?

----
Dale


__________ Information from ESET Smart Security, version of virus
signature database 4791 (20100120) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4791 (20100120) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Dale Fye]

Guys,

Appreciate your responses. I would really like to avoid having two separate
data sources (and the work required to keep them synchronized). Our
application is currently written in Access, using SharePoint lists as the
data source (long story).

Given the comment that Project cannot read from Access unless the data is in
the right format, the question becomes, how can I use Access to
view/manipulate the data that is in a Project file? Or can I?

If I can, then I could add/delete/change data in the Project file directly
from Access. This would obviously require some knowledge of the Project
Object model, but more importantly, a knowledge of the project data structure.

 

[JulieS]

Hi Dale,

As Rod Gill noted, unless you are using Access 2003 (which you aren't)
you'll need to read and manipulate the data through code. JohnR posted
a link to the information on MSDN about the data access model.

I'll also put in a strong plug for investing Rod's excellent book on
Project VBA. See:

http://www.projectvbabook.com/


Julie

 

[0]

Unless your Access database is structured exactly as Project needs it then
the only way to read data from any database in Project 2007 onwards is
using VBA code, either in Access to push data to Project or in Project to
pull data from Access. Project 2003 and earlier does have an ODBC link and
you can create a map to map fields in Access to fields in Project. This
does not link data, but does import to Project.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com






__________ Information from ESET Smart Security, version of virus
signature database 4791 (20100120) __________

The message was checked by ESET Smart Security.

http://www.eset.com

hallo