Connection strings for MS Project

Project 2007, unlike Project 2003, does not include an OLE DB Provider. To query Project data programmatically, use the Microsoft Office Project Server reporting store or the reporting cubes. The Reporting database is used for read-only, server-side data access. Data access to local .mdb files from Project Standard or Project Professional is accomplished through the VBA object model.

You can also save projects as XML files for access to project data. It is also possible to save your mpp project file in a 2003 format and use the Microsoft.Project.OLEDB.11.0 provider.

Another option is to use the 2003 Microsoft.Project.OLEDB.11.0 provider to connect to the 2007 mpp file. Please note that for this to work service pack 3 for Project 2003 must be installed.

OLE DB providers for MS Project

• Microsoft Project 2003 OLE DB
• Microsoft Project 2002 OLE DB
• Microsoft Project 2000 OLE DB

.NET libraries for MS Project

• .NET Framework Data Provider for OLE DB - OleDbConnection

Forum for MS Project