Struggling to get Project Data into Excel using OLE DB

[john.kaye]

I have created a data source (an ODC File) using the wizards in Excel
with Project OLEDB. The Test connection button works and when I open
the file in Internet Explorer, Office Web Components allows me to
create a PivotTable of the data. When I open it through Excel, Excel
says the query did not run or the database table could not be opened:

The connection is:
Provider=Microsoft.Project.OLEDB.11.0;User ID="";Data Source="";Project
Name=Z:\\My Documents\\H06802S.mpp;Enterprise Mode=False;Always
Load=False;Initial Catalog=Z:\\My Documents\\H06802S.mpp;Persist
Security Info=False;Enterprise RUID List="";Initial Catalog=(Default)

The Command Type is Table

The Command Text is Assignments

Does anyone know what I need to do to get this to work?
Have you got samples which do work?
Thank you.
Best Wishes, John.

 

[Rod Gill]

Hi,

The oledb interface is meant to work from code. I have never tried using it
from Excel. I suspect that it may not work, and if it does then you will
only see Assignment data, but Task details will be the ID number.

Read the file pjoledb.htm installed in one of Project's program folders.