Faster way of extracting data from Project?

[dgmoore]

I need to extract data from some tables that Project does not expose
through ADO: MSP_LINKS, MSP_TEXT_FIELDS, MSP_DATE_FIELDS and a couple
of others.

I am currently extracting the data I need by populating a table in
Access by traversing the Project file using automation. That way I can
append a record to the Access table and populate all of the fields I
need: T.Start1, T.Text3, T.Number4, whatever.

This approach works fine, but it takes 7 minutes to populate a table
with about 8,000 rows. The source file continues to grow, so the amount
of time to do the extraction is also increasing. Since this process is
performed daily, I'd like to find a way to speed it up.

Does anybody have any suggestions?

Thanks
Dave

 

[Rod Gill]

Hi,

Project 2003 has a Predecessors table for links, CustomFields and
CustomFieldValueList tables for text and date fields not already in the
Tasks table. See pjdb.htm for details.

Note that Project 2007 does not support OLEDB unless files are saved in 2003
format and you download the oledb reader, so oledb as a solution has a
limited life. In future you will probably need to store projects in a
database and read from the database or if you use Project Server 2007+ read
from the new reporting database.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[dgmoore]

Maybe I should just leave my process alone until we upgrade to Proj07,
which at the rate we adopt software upgrades will be sometime after I
retire. Sounds like my problem is solved without my having to do
anything at all!
Thanks
Dave