How to connect access 2003 to an mpp file

[Jeff L]

Is there a simple way of importing data from microsft project to access 2003?

I am trying to extract data from a microsoft project (.mpp) file. I can find
instructions for Access 2002 which has a wizard with the option "Microsoft
project 10.0 OLE DB provider"

This does not appear as an option in the Access 2003 wizard. Do I need an
add in?

 

[Arvin Meyer MVP]

I believe the data was directly available through Data Access Pages, but you
may be able to use ADO to access the OLEDB provider. Have a look at the
following article from MSDN:

http://msdn.microsoft.com/en-us/library/aa140134(office.10).aspx#projoledb_topic3

 

[Jeff L]

Still the same problem.

I have found that MSP 2003 has Microsoft project 11.0 OLE DB provider

I still cannot link to this from Access via the wizard

What do I have to do in Access to get the microsoft project tables?
--
Thanks for your help
Jeff L

I believe the data was directly available through Data Access Pages, but you
may be able to use ADO to access the OLEDB provider. Have a look at the
following article from MSDN:

http://msdn.microsoft.com/en-us/library/aa140134(office.10).aspx#projoledb_topic3

 

[Bre-x]

I think you have to save the mpp as ms access file

Bre-x

Still the same problem.

I have found that MSP 2003 has Microsoft project 11.0 OLE DB provider

I still cannot link to this from Access via the wizard

What do I have to do in Access to get the microsoft project tables?

 

[NevilleT]

We have a white paper on using Access to report from Microsoft Project. Hope
it is useful
http://www.projectperfect.com.au/info_msp_reports.php

Neville Turbit
www.projectperfect.com.au

 

[Arvin Meyer [MVP]]

You folks were my next suggestion as you have done quite a bit of work with
Access and Project.