Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



importing dates from ms excel into ms project

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 13-12-2011
Member
 
Join Date: Dec 2011
Posts: 1
importing dates from ms excel into ms project

we have an issue where we get an excel report ( our PMO dept uses MS EXCEL) from which we have like products

like so

product 1 start date end date

product 2

.

.

.

product x



each product has a product life cycle which we are trying to put into MS project. I wanted to know a couple of things:

-note: the products and dates change and as such need to be reflected in MS project (that is why i needed to do manual linking)



1. is there an automatic/easier way to "link" all the start/end dates into ms project which at the moment is very cumbersome given the crazy amount of products we have (horribly manual error prone process)? via programming or maybe i can put the ms excel file into another file format which ms project can easily get somehow?



2. I am trying to have multiple products within one project plan. So, i defined the first product and its tasks/milestones with proper linking (both kinds linking with ms excel dates and linking internally of tasks like FS/FF etc). Now is it possible to just simply copy and paste the rest without losing any linking? apparently this is also a problem i am having.



I need serious help on this. I would really appreciate it since i am very new to ms project and trying to convince our company to use this instead of just all sorts of ms excel sheets.



thanks

Reply With Quote
  #2  
Old 13-12-2011
Member
 
Join Date: Dec 2007
Posts: 2,261
Re: importing dates from ms excel into ms project

Follow the below method and see if it works for you or not:
  1. Click Open.
  2. In the Files of type box, click the file type you want to import data from.
    • To import data from a SQL Server or Oracle Server format, click ODBC to connect to your data source, and then continue with step 5.
  3. In the Look in box, locate the folder that contains the file you want to import, and then select the file in the file list.
    • If needed, you can search for the file.
  4. Click Open.
  5. Follow the instructions in the Import Wizard to import the data you want into the proper Microsoft Office Project fields.
Reply With Quote
  #3  
Old 14-12-2011
Member
 
Join Date: Dec 2006
Posts: 489
Re: importing dates from ms excel into ms project

Quote:
Originally Posted by tazor View Post
we have an issue where we get an excel report ( our PMO dept uses MS EXCEL) from which we have like products

like so

product 1 start date end date

product 2

.

.

.

product x



each product has a product life cycle which we are trying to put into MS project. I wanted to know a couple of things:

-note: the products and dates change and as such need to be reflected in MS project (that is why i needed to do manual linking)



1. is there an automatic/easier way to "link" all the start/end dates into ms project which at the moment is very cumbersome given the crazy amount of products we have (horribly manual error prone process)? via programming or maybe i can put the ms excel file into another file format which ms project can easily get somehow?



2. I am trying to have multiple products within one project plan. So, i defined the first product and its tasks/milestones with proper linking (both kinds linking with ms excel dates and linking internally of tasks like FS/FF etc). Now is it possible to just simply copy and paste the rest without losing any linking? apparently this is also a problem i am having.



I need serious help on this. I would really appreciate it since i am very new to ms project and trying to convince our company to use this instead of just all sorts of ms excel sheets.



thanks
You can select multiple tasks and use the "Link tasks" button to link F to S sequentially. For example: Task A, Task B, Task C, Task D.
Select all four tasks and the resulting links will be
Task A is predecessor to Task B in a Finish to Start link
Task B is predecessor to Task C in a Finish to Start link
Task C is predecessor to Task D in a Finish to Start link

To your question about copy/paste - yes. Just ensure you select by the row number to capture all task information.

You can define predecessors in Excel and then import -- but be cautious about Task ID versus Excel row number.

I hope this helps.
Julie
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "importing dates from ms excel into ms project"
Thread Thread Starter Forum Replies Last Post
MS-Project > Linked tasks, but dates dont' move BefuddledSearcher Windows Software 2 30-01-2012 07:27 PM
MS Project 2003 - show dates in the header of the report shoppingboy Windows Software 2 28-03-2011 01:08 PM
Subtracting dates in Project 2007 taylok11 Windows Software 1 25-06-2010 12:46 PM
Error on importing project in MS-Project 2003 fredpaquet Windows Software 4 24-04-2009 05:06 AM
Understanding Project tasks and dates Javan Windows Software 2 05-09-2008 11:32 AM


All times are GMT +5.5. The time now is 11:16 AM.