Programatically saving microsoft project in sql server 2000

[Strider]

Hi

I 'm currently trying to develop a C# windows application which will allow a
user to specify some basic project info ( like start , end dates and stuff)
and save the project in a sql server 2000 database.
I could create the required sql server tables by exporting a mpp file to sql
server 2000 using the ODBC option available while saving.
I would like to know , how could the same be acheived ( i.e saving a mpp to
sql server 2000) programatically.
I'm using the microsoft project 9.0 object library which does provide a
'ProjectClass' object which can be populated. Can anyone please suggest as to
how save this project object into sql server 2000 (using c#/vb.net code) ?

 

[Rod Gill]

Hi,

You have two choices:

1) Use Office automation to create the project in Project itself, then save
to SQL Server.

2) Write data directly to the SQL Server database. Find the file prjdb.htm
in one of Project's program folders for all the details on how to do this.
This method means you can bypass Project, you won't even need it installed
on the PC running your code.

 

[Strider]

Hey thanks Rod , the projdb.htm file has it all.
Cheers