import data from excel into row zero of multiple project files

K

kdjones

I want to import multiple rows of data from an access database into Project
Server. Specifically, I want the data to populate custom fields in "row
zero" of existing project plans that are published to project Server. Is
there a way?
 
R

Rod Gill

Hi,

The PSI interface can be used to do this, but in much less time VBA code can
do the same thing. In Project VBA I would:

Read Project data from the Access database using OLEDB

For each record
Open the project in Project Professional
Update the Custom fields
Save and Publish the project
Close the project
Next Record

The user would need an account that can has permission to open and update
all projects (EG be a project server admin).
--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
K

kdjones

sounds feasible. Now if I can just find a VBA programer to write that code I
will be all set. thanks for giving me a direction to pursue. -Kevin Jones
 
K

kdjones

I would be interested in your price. I will send you a separate email from
your website.
 
Top