Do standard MS Project mpp files have databases that can be queried?
Posted on 2016-09-06
I have a standard MS Project 2010 mpp file. I would like to read the data in it by querying it like a database. I understand that MS Project Servers have databases that can be read, but I'm wondering if just plain vanilla MS Project files also have databases that can also be read.
I tried using ADODB with the following connect string with no success:
This string I'm using is one for MS Project 2003 recommended by the ConnectStrings website. I also tried OLEDB.12, 13, 14, and 15 with no success.
Is what I am trying to do impossible? Do I just need to use a different connection string?
A complete discussion of how to connect, or why I can't connect would be much appreciated.