Project Automation

[simon p]

Hi

I have a need to modify a custom field in Project 2007 from exisitng data in
an SQL Database.

I understand that the Project 2007 Modle is to use Project Server and
customise from there, but it seems a bit of overkill for this particular
project (and I've had trouble in setting-up a Project 2007 Test Server
anyway!).

Is there any way I can get an ODBC/OLE_DB connection to the Project file ?

Simon

 

[Rod Gill]

Firstly the 2003 oledb driver is read only (2007 does not support oledb)

You can update the database directly, but this is not supported in 2007.

Best version independent way to update a custom field is via automation.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[simon p]

Thanks for the prompt resposne Rob.

When you say automation, do you mean via Macro's/VBA within project looking
outside to SQL ?

Si

 

[Rod Gill]

No,

Yes. Have Project open, then in Project VBA, or any other language read the
data from SQL Server and store the results in required fields.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx