Build Project files regularly from ground up

[Jürgen Beck]

I have to build project (Version 2000) files regularly from ground up with
time-information from a database.

What is the best way to do this?

I'm developer and not afraid to code VBA- or SQL-statements.

Is it possible to connect a SQL Server with a mpp-file and the Project-OLE
DB Provider to insert rows directly into the project-file?

Thanks for any advise,
Jürgen

 

[Rod Gill]

Hi,

Yes you can connect to a SQL server. Create a DSN file then save a project
to it. Project creates all the tables etc automatically. Search for the file
projdb.htm in one of project's program files. It explains the schema and how
to add data.

No you can't write using the Oledb interface: it's read only.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[Jürgen Beck]

Yes you can connect to a SQL server. Create a DSN file then save a project
to it. Project creates all the tables etc automatically. Search for the
file
projdb.htm in one of project's program files. It explains the schema and
how
to add data.

Thanks for this information.

How can I connect my Project to a SQL Server? I thought a mpp-file is all my
Project can understand and I need a Project Server for a SQL Server support?

Thanks,
Jürgen Beck

 

[Rod Gill]

Hi,

Create a system DSN and in File Save as dialog click the ODBC button. Select
your DSN and Project connects and if the database doesn't exist, it creates
it and then prompts you for a project title. You don't need Project Server
for SQL Server support: ODBC connectivity to any ODBC source is built in.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[Jürgen Beck]

Create a system DSN and in File Save as dialog click the ODBC button.
Select
your DSN and Project connects and if the database doesn't exist, it
creates
it and then prompts you for a project title. You don't need Project Server
for SQL Server support: ODBC connectivity to any ODBC source is built in.

Hi Rod,

I did it with VBA and the Project object modell. It was pretty easy.

Thanks for your help.

Jürgen Beck