How to connect access 2003 to an mpp file

  • Thread starter Thread starter Jeff L
  • Start date Start date
J

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?
 
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


Arvin Meyer MVP said:
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
Click to expand...
 
I think you have to save the mpp as ms access file

Bre-x


Jeff L said:
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?
Click to expand...
 
You folks were my next suggestion as you have done quite a bit of work with
Access and Project.
 
Back
Top