Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



MS Project 2007 Resource Import from Excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 20-03-2012
Member
 
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?

Reply With Quote
  #2  
Old 21-03-2012
Member
 
Join Date: Dec 2007
Posts: 1,702
Re: MS Project 2007 Resource Import from Excel

Check some suggestions given in similar type of threads here - http://forums.techarena.in/microsoft...ct/1060844.htm
Importing Excel Spreadsheet
http://forums.techarena.in/microsoft...ct/1392948.htm
http://forums.techarena.in/microsoft...ct/1089951.htm
Reply With Quote
  #3  
Old 24-03-2012
Member
 
Join Date: Dec 2006
Posts: 479
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/
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 09:12 PM.