Unable to read mpp file using ACCESS VBA

I had written a code using MSProject OLEDB.11.0. The code works fine for MS Project 2003. I am able to successfully read mpp files. But when I try using the code in MS Project 2007, I get the following error:
'Provider cannot be found. It may not be properly installed'
I googled and found that I could use OLEDB 12.0 and had to install the latest connectivity driver. Which I did and I stil  get the error.
Please help as I need to set it up for demo soon.
address = strDirName & strFileName
          cnnProj.Open "Provider = Microsoft.Project.OLEDB.12.0; Project Name =" & address
          rstTasksProj.Open "SELECT TaskName, TaskStart, TaskFinish,TaskText1,TaskResourceNames, TaskNotes, TaskUniqueID, TaskPercentComplete FROM tasks where taskuniqueid > 0 and TaskText1 <> '' ", cnnProj

Open in new window

Who is Participating?
rnemaniConnect With a Mentor Author Commented:
I solved the problem by getting a csv file from the project server
Have you checked your references?  You probably need the Microsoft Project 12.0 Object Library.
What is cnnProj declared as ?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.