Bulk load of Resources with more than 1 availability

[Steve Scott]

I have 260 + resources with 3 different availability units for Oct, Nov and
Dec respectively. I want to bulk import the info into project, the tricky
bit is the 3 availability periods and associated units. I have tried saving
a blank project file to mdb format and entering the data into the
availability table and then re-importing the mdb file into a new project file
but it is not showing the new availability and associated units data.

Is what I am trying to do possible? Is there an easier way? Is there any
code I use anywhere to achieve this?

Thanks in advance.

Steve

 

[Jan De Messemaeker]

Hi,

You can write a VBA procedure that writes to the Availabilities collection
of the resource object.
HTH

 

[Steve Scott]

Thanks, I have no idea how to write VBA and need to get this sorted urgently.
I have tried apending the additional availability data directly into the
availability table in an access export but when I reimport into project the
changes have not been affected. Why is this happening and how do I get
ropund it? Appending the data into access seems the best approach but
something is preventing it from working.

Thanks in advance.