Hi Jillca,
Access to Project is easier than Project to Access - but how difficult it is
depends on exactly what you wish to export and what format the respective
tables are in.
Assuming 2007 versions (what I just checked things out with) then the best
seems to be export from Project as XML, Import the XML as multiple tables.
Once you have your data into Access, then construct queries that append the
data you wish to migrate from the respective tables to the Access tables.
This is something you could do in a couple hours.
Once you get the Project Table columns mapped to your Access Table columns
and recorded as queries, you can create a macro that cleans out the old XML
tables in Access, imports the newest XML file, runs each of the action
queries that you have created.
You could fully automate the export by using office automation to trigger
the export in Project but that's out of my pay grade - at least for this
venue! It would take some research on my part into the Project Application
Object Model. If you are getting that deep into VBA then you can do it
either direction, by working with the respective Application objects. Doing
it this way could take quite a while to get it working the way you want to -
not sure the cost-benefit is there unless you add in the value of the
lessons learned while doing it and assuming that the person signing the
checks is willing to subsidize this kind of intangible payoff.
Hope this helps...
Gordon
