How to integrate date from MS Project to MS Access

Can anyone send me a good link to explain how I can integrate dates from MS Project into my MS Access database?
LillyCDatabase DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Richard DanekeTrainerCommented:
You may try the trial ODBC connector available here:
https://www.cdata.com/drivers/msproject/odbc/

This will permit imported or linked tables to be used in Access.  There is a subscription cost to this product.

The other option would be to use VBA to open the Project file.  Modules would be coded to use this data.

This link shows some discussion on using the Project reference libraries in VBA and some good error coding:
https://social.msdn.microsoft.com/Forums/en-US/ec4aec3b-4fc9-4646-a0b6-3921788c7255/how-to-programmatically-open-ms-project-and-run-vba-macro

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LillyCDatabase DeveloperAuthor Commented:
Thanks very much Richard I'll take a look link.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MS Project

From novice to tech pro — start learning today.