Getting Data out of MS Project

  • Thread starter Thread starter Goofy
  • Start date Start date
G

Goofy

Hi,

We have a situation where there is a requirement to extract and report data
to an ASP.NET/VB application from a MSOffice 2003 application.

Best idea to be able to get to the Data ? I know there is a COM Interop
available but have not looked at it yet.

Or any other ideas greatly appreciated

Regards
 
Goofy said:
Best idea to be able to get to the Data ?
Click to expand...

If it's MS Project you're reading from, they have an OLE DB database driver
you can use. Lots of information can be found here:

http://www.microsoft.com/technet/prodtechnol/project/project2000/maintain/prjoledb.mspx

I recently used this to write some code to extract all the data from a
project file and store it in a database, and it worked very well.

Some things I found along the way:

1. I couldn't get this to work using ADO.NET. It kept giving me memory
access errors. Instead I dropped back to ADO Classic, and then it worked
fine.

2. The only way to install the driver on a PC appears to be to install the
whole of MS Project. Be aware of the licensing/product activation
implications of this.

3. It appears to be OK to omit the version number from the connection string
(i.e., "Provider=Microsoft.Project.OLEDB; Project Name=..."). This has
worked on every PC I've tried it on, whereas providing a specific version
number obviously requires that specific version of Project to be installed.
Should you wish to provide a version number, the versions appear to be 9 for
Project 2000, 10 for Project 2002 and 11 for Project 2003.

I hope that helps,
 
Thanks for your help


Oenone said:
If it's MS Project you're reading from, they have an OLE DB database
driver you can use. Lots of information can be found here:

http://www.microsoft.com/technet/prodtechnol/project/project2000/maintain/prjoledb.mspx

I recently used this to write some code to extract all the data from a
project file and store it in a database, and it worked very well.

Some things I found along the way:

1. I couldn't get this to work using ADO.NET. It kept giving me memory
access errors. Instead I dropped back to ADO Classic, and then it worked
fine.

2. The only way to install the driver on a PC appears to be to install the
whole of MS Project. Be aware of the licensing/product activation
implications of this.

3. It appears to be OK to omit the version number from the connection
string (i.e., "Provider=Microsoft.Project.OLEDB; Project Name=..."). This
has worked on every PC I've tried it on, whereas providing a specific
version number obviously requires that specific version of Project to be
installed. Should you wish to provide a version number, the versions
appear to be 9 for Project 2000, 10 for Project 2002 and 11 for Project
2003.

I hope that helps,
Click to expand...
 
Back
Top