Importing Project 2003 files to SQL

[geoff]

I have an extensive website based on the Microsoft Project 2003 database
schema, and it works great for displaying and reporting on Project data, but
the big problem is that the only way I know of to get data into the database
in the first place is to load a project in the thick client, then use the
Save As feature to save it to the databse via an ODBC datasource.

I know that there has to be another way to do this, because I know of other
3rd party applications that allow you to import and export MS Project files.

Ideally I would like to use a SQL server Scheduled Job to automatically
import the files nightly, or something like that, but any method that can be
used to import the files via code, instead of using the Project front end
would be good.

I searched everywhere I know to search, I've downloaded the SDKs, but I
still don't have a solution, but I know that there has to be one.

Any ideas welcome.

Thanks

 

[Adam Behrle]

Geoff,

You can open the mpp as read-only through an OLE DB connection using
the OLE DB provider.

Search for the article "Getting Started: Developing with Project 2003"
on msdn and checkout the section "OLE DB Provider". That should point
you in the right direction.

Hope that helps!

Adam

 

[geoff]

The problem here is the Project OLE DB Provider.

I have MS Project Professional 2003 installed, but I don't have any Project
OLD DB Provider. So, what is this Project OLE DB Provider, and how do I
install it?

Thank you

 

[geoff]

Also, I should note that perhaps it is installed, but I stil have a problem.

When using MS SQL 2005, if I try to use the Import Wazard from a selected
database, then I see MS Project 11.0 OLE DB Provider as an option, but when I
select that option, then go to "Options..." in order to configure the
connection, there is a field for "Location" which is disabled and I can find
no way to enable it. It seems that this "Location" is what I would need to
set with SQL in order to make ti work, and I don't know why its disabled.

If that we availible then I could easily create a SQL job, but maybe I can
still just set that field programtically.

I'll see what I can do there.

Thanks.

 

[Adam Behrle]

Geoff,

It should be installed. Checkotu the PJOLEDB.HTM page in your the
Office11 installation folder.

You'll see to use it, you specify a connection string like so:

Provider=Microsoft.Project.OLEDB.11.0;PROJECT NAME={mpp file name}

Adam

 

[geoff]

Thanks Adam.

You are right, it was installed. I was expecting to see it in my list of
ODBC datasources.

I'm able to create a connection and read from the files now.

Thanks for you help. I still have the problem that I noted in my other post,
about creating SQL Import jobs, but I wil be able to work around it one way
or another now.

Thanks