Export to Ms Project or Ms Access

P

Prav

Hi I have an Ms Database and Ms Project that stores information about
projects. The projects can be approved or non approved. Each project have a
project number, start date, finish date, design hours, management hours and
issues hours. There are two resource type - ENG1 and ENG2
So the Gantt Chart structure is like this

ENG1
--------APPROVED
---------------------PROJECT NUMBER
------------------------------------------- DESIGN
------------------------------------------ MANAGEMENT
------------------------------------------ ISSUES
--------NON APPROVED
---------------------PROJECT NUMBER
------------------------------------------- DESIGN
------------------------------------------ MANAGEMENT
------------------------------------------ ISSUES

Same for ENG2.

My problem is i have to update the database and the gantt chart, so there is
a duplication. The gantt chart is used to produce the resource graphs for
ENG1 and ENG2. How can i export the data from my database to match the fields
in the gantt chart or vice versa. Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify the gantt chart view in project center (WPA) (MS Project 2010) 0
MS Project Overwrites Max. Resource hrs 0
MSPS 2010 - linking Issue (or Risk) to Project Plan 0
3 variable data in MS project file 0
Export Information From MS Access to MS Project 2
MS Project 2016 - all tasks not showing in Calendar View 0
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
MS Project daily project 5

Top