cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft Project data connection

Former Member
0 Kudos

I am using CR XI and Microsoft Project 2003. I am attempting to connect to a project .mpp file using the Microsoft Project OLE DB 11.0 Provider. If I put the path in the Data Source fill in and the name of the file, including the .mpp extension, in the Database fill in, I get the error message for failure to find the file, error # 80004005. If I type the full path and file name in the Database fill in box, the connection comes in with the name "Connection" and shows the project file tables list, but all of the tables contain the same fields which appear to be the properties for the file, not the project task information. How do I connect to a project file?

Thanks,

Jim

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi Jim,

Moved to the database forum.

If you can create a UDL file by opening Notepad and save the text file as MyConnection.txt and then rename it to *.udl. Double click on the file and it should open the OLE dB connection wizard. Select all of the option to connect to your mpp file and see if that works.

If not I recall if CR can use them and you'll have to use OLE DB and connect to the DB that way.

Thank you

Don