Automatic Resource Assignment

[JD]

Hey, I am working with a database that has a huge list of tasks, resources,
and a lot of other stuff. The resource table has IDs that refer to which
task it belongs to. The tasks can have two more resources, or none at all.
Is there a way that I can import the resource data and have project
automatically assign them to the corresponding task? I don't really need any
information about the resources, they are just different departments in the
company, all I need is to show which task they are assigned to.

 

[Jan De Messemaeker]

Hi JD,

It all depennds on the format of the table, but the way you describe it, I
guess you will need some programming.
HTH
Jan

 

[JD]

Right now I am importing two tables, one for the tasks, and one for
resources. I could make a new query in Access if there is a better way to do
it.

 

[Jan De Messemaeker]

Hi,

Looks to me importing the resource names into the resource names column is
the simplest way.
Using the oobect model to import through VBA is also a possibility.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[JD]

That would work, but I have the problem of multiple resources being assigned
to the tasks. Should I figure out a way to fix that in Access, or can
Project take care of it somehow?

 

[Jan De Messemaeker]

Hi,

The Resource names field accepts multiple resource for a task, separated by
the list separator character (; in Europe or , in US)
I know absolutely nothing about queries so there I can't help you.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf