|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
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. This implies that the ODC file is
correct. But 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.
|
|
|