Linking MS Project into Access

[DC27]

Looking for guidance / books / help with this.

Basically, I have a portfolio plan with about 50 linked projects. I have to manually export data into excel to manipulate and report.

What I'd like to be able to do is have an Access database to read (or read/write - now that would be MAGIC) the linked project data. That way i could avoid all the exporting, copying, pasting, manual intervention that i currently do.

Anyone else done something similar?

We're using Project 2003 and I can use Access 2003 or 2010 - i prefer 2010, but I'm guessing there's some nuances i've need to consider here.

Thanks
David

 

[boblarson]

You can sort of link to it using COM (Common Object Model) in VBA. But it wouldn't be "linking" in the true sense of the word. About 5 years ago I was tasked at my job then to do some stuff programmatically in Project actually in Project. It is not impossible to do but it does take a bit of learning the objects and how to use them. I don't think I can give a tutorial here but, if I remember correctly, this is the book I used to start working with the VBA:
http://www.amazon.com/Microsoft-Off...&sr=1-1&keywords=Microsoft+Project+2003+bible