Import data from Excel with main tasks and subtasks

[Franseza]

I have a data in MS Excel consisting start dates, End dates, Work Request numbers, individual phase numbers for the Work Request, and name of each phase. I wanted to import this data from Excel to Project 2000 with main tasks and subtasks. Well, I tried importing it but when I open the file in project after mapping the fields, surprisingly the data shows up as individual tasks. do I need to change the data layout in the Excel file in order to correct this? Somebody please provide me a proper way to specify this within Project. Thank you very much.

[Beckinsale]

I don’t know what can be done in the Project 2003 itself to fix it but from Excel end, you should try adding a field to the Excel sheet called Outline Level. Once done, populate it with 1,2,3 or 4 and then import the same in MS Project with corresponding Outline Level field. If you want to do it from Project end, then you will need to quite Project 2000 and upgrade to MSP 2010. In this latest edition, you can do it easily by cut/paste it from Excel while retaining the outline structure. Hope it helps you.

[JulieS]

Great, glad to hear you were able to work things through Amy. To answer your earlier question about where to go with future questions see the forums:

http://social.technet.microsoft.com/...ofessional2010


Julie
Project MVP