Moving a task list from Excel

J

JulieS

Hi John,

You have several options:

You could copy the names of the task(s) and durations(s) and paste into a
Project file. Project will then calculate the start and finish dates of the
tasks based upon the start date (or end date) of the Project as set in
Project>Project information and the Project calendar. You could then use
Project to create the links between the tasks. I do not recommend copying
the Start and Finish dates from the Excel file and pasting into the Start
and Finish dates in Project as this will create constraints.

You could also open the file in Project and then create a map to map the
Excel columns into the Project fields. Again, I would not import any dates
into the Start and Finish fields in Project as this will create constraints.

Let us know if you need specific directions on either method. Hope this
helps. Let us know how you get along.

Julie
 
J

John W. IV

Thank you, JUlieS. I'll give both a try.

JulieS said:
Hi John,

You have several options:

You could copy the names of the task(s) and durations(s) and paste into a
Project file. Project will then calculate the start and finish dates of the
tasks based upon the start date (or end date) of the Project as set in
Project>Project information and the Project calendar. You could then use
Project to create the links between the tasks. I do not recommend copying
the Start and Finish dates from the Excel file and pasting into the Start
and Finish dates in Project as this will create constraints.

You could also open the file in Project and then create a map to map the
Excel columns into the Project fields. Again, I would not import any dates
into the Start and Finish fields in Project as this will create constraints.

Let us know if you need specific directions on either method. Hope this
helps. Let us know how you get along.

Julie
Click to expand...
 
J

JulieS

Hi John,
You're welcome and thanks for the feedback. Let us know if you have any
questions.
Julie
 

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

Auto populate value from one task to another in MS PROJECT 0
Re-title multiple MS Project .mpp files at once 0
How to implement two shifts per day with multiple teams 0
Projects and Tasks without a Start date and/or finish date:MS Project 2007 1
MS Project 2016 - all tasks not showing in Calendar View 0
MS Project - error message when checking "Critical tasks" 1
Need Help with Macro Security 1
Request Form - Alert Team Member 0

Top