A
amycwhitfield
I'm new to MS Project and need help with importing data from Excel into
Project 2000. The data consists of Work Request numbers, individual phase
numbers for the Work Request, name of each phase, and (phase) start and end
dates.
I can open the Excel file in Project and map the fields, however, the data
shows up as individual tasks. I need to have the Work Request number and
project name be a main, or top-level, task, and the data related to the
phases be sub-tasks.
Here's an example of how the raw data appears in the Excel file:
WorkReq# ProjectName
Phase# PhaseName StartDate EndDate
Note there's typically more than one phase per Work Request, just trying to
keep it simple in the example.
Is there a way to specify this within Project, or do I need to change the
data layout in the Excel file?
Any help, thoughts, etc is greatly appreciated!!!
Project 2000. The data consists of Work Request numbers, individual phase
numbers for the Work Request, name of each phase, and (phase) start and end
dates.
I can open the Excel file in Project and map the fields, however, the data
shows up as individual tasks. I need to have the Work Request number and
project name be a main, or top-level, task, and the data related to the
phases be sub-tasks.
Here's an example of how the raw data appears in the Excel file:
WorkReq# ProjectName
Phase# PhaseName StartDate EndDate
Note there's typically more than one phase per Work Request, just trying to
keep it simple in the example.
Is there a way to specify this within Project, or do I need to change the
data layout in the Excel file?
Any help, thoughts, etc is greatly appreciated!!!