Linking to data from Microsoft Project

[Arnold Roth]

Is there any way to link Access cells to data contained in
Microsoft Project? I'm trying to do statusing of various
reports. There is a schedule for these reports that exists
on a Project file and I would like to be able to link the
start and finish dates for the reports from Project into
Access.

I don't see anything in the help files which seems to
pertain to this. Can anyone help?

Thanks much

 

[Larry Linson]

I believe you can... in fact, I suspect that you can control Microsoft
Project via COM Automation from Access, and probably can control Access via
COM Automation from Project. To do either, you'll need to understand the COM
Automation process and the Object Model of the Software that you want to
control.

Larry Linson
Microsoft Access MVP

 

[Arnold Roth]

Thanks, Larry. I've never heard of COM automation. Can
you lead me to somewhere I can learn about it?

Thanks