Exporting Data

[ClK]

Can I export data from Access 2003 to a Microsoft Project? I need to be able to create Gantt charts from Target dates and completed milestones.

 

[ClK]

Okay, I believe I know that data indeed can be exported to MIcrosoft Project. Next question, how do I do that? I want to export dates to create Project Gantt charts and import the Gantts to be viewed in Access. Can that be done?

 

[SydneyGeek]

Work from the Project side and try importing instead. You may find that you need to push the Access data to Excel, then pull it into Project.

I'd suggest exporting some dummy data from Project (File > Save As > Excel, then choose one of the existing Task export maps) so you can get the correct structure.
Then push out from Access with the same structure, and import the data into Project.

Denis