Results 1 to 3 of 3

Thread: MS Project 2007 Resource Import from Excel

  1. #1
    Join Date
    Mar 2012
    Posts
    1

    MS Project 2007 Resource Import from Excel

    Does anyone have experience in Importing Resource Assignments from Excel to Project 2007? When I attempt the import, it never works --Resources seem to be randomly assigned to tasks, even tasks that I'm not assigning anything to. I am setting WBS up as the merge key (actually, I've tried many different merge keys as well including Task Unique ID, Resource Unique ID, Text1, etc.). The assignments never come in correctly. Can anybody provide some insight on how to successfully accomplish this import?

  2. #2
    Join Date
    Dec 2007
    Posts
    1,742

  3. #3
    Join Date
    Dec 2006
    Posts
    489

    Re: MS Project 2007 Resource Import from Excel

    Quote Originally Posted by ronberrype View Post
    Does anyone have experience in Importing Resource Assignments from Excel to Project 2007? When I attempt the import, it never works --Resources seem to be randomly assigned to tasks, even tasks that I'm not assigning anything to. I am setting WBS up as the merge key (actually, I've tried many different merge keys as well including Task Unique ID, Resource Unique ID, Text1, etc.). The assignments never come in correctly. Can anybody provide some insight on how to successfully accomplish this import?
    I would not attempt to create assignments by importing. Project must create the assignment ID when it creates assignments. Is there a reason why you are not creating the assignment in project? You cannot also merge assignments into project -- you have to create them. If you wish to alter assignment data after creating - export out from Project and then use the Assignment Unique ID to merge data back in.

    Also, in the future, you may wish to post your questions regarding Microsoft Project directly to the project forum here at Techarena. See:

    http://forums.techarena.in/microsoft-project/

Similar Threads

  1. Resource modeling in Project 2007
    By kevinarthur_99 in forum Windows Software
    Replies: 1
    Last Post: 01-05-2011, 03:41 AM
  2. Import from Excel to MS Project , Strange Prob!!
    By kizzie37 in forum Windows Software
    Replies: 2
    Last Post: 09-03-2011, 10:53 PM
  3. Project 2007 - Resource Calendar
    By shyman in forum Microsoft Project
    Replies: 5
    Last Post: 06-04-2010, 06:11 PM
  4. Link excel cells to MS Project Resource Usage
    By alebertoni85 in forum Windows Software
    Replies: 7
    Last Post: 31-12-2009, 08:31 AM
  5. Why won't Project Import/Export to/from Excel
    By aghuvi in forum Microsoft Project
    Replies: 2
    Last Post: 19-12-2008, 05:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •