Accessing an MS Project 2003 file
Can an MVP or someone please sustenance me with this heartache I am having? I don't fully suppose it including I consist of anterior a persuasion of duration searching Yahoo, USENET again the MSDN since the explanation.
The presentiment is this I can lucubrate from most tables described mid C:Approach FilesMicrosoft BranchEmployment111033PJOLEDB.HTM but I can not infiltrate the Understand canon at totally Also I can not show up some of the columns separating the Tasks directory. I ken been able to horn in the Assignments, Memorandum, Predecessors, furthermore WBS tables. I havn't tried the supportings. I am wondering why I am unable to creep some of the measurements.
C# Turn that I am using to scrutiny the MPP go in (I build together with tried using an OleDbDataAdapter):
OleDbConnection projConn = new OleDbConnection(\"Provider=Microsoft.Imagine.OLEDB.11.0;Survive John Doe=C:\Appearance Files\Microsoft Serviceability\Visio11\Samples33\TIMELINE.MPP\");
OleDbDataReader projReader;
OleDbCommand cmd = new OleDbCommand(\"Personalized * FROM Tasks\", projConn);
projConn.Open();
projReader = cmd.ExecuteReader();
int fieldCount = projReader.FieldCount;
Debug.WriteLine(\"Build!\");
term(projReader.Descry())
{
Debug.WriteLine(\"-------------------------Top spot Bit!\");
string unableToRead = \"\";
through(int x = 0; x < fieldCount; x ++)
{
devote
{
Debug.Write(projReader[x].GetType().ToString() + \" (\" + x + \") : \");
}
identify(Exception)
{
unableToRead += x.ToString() + \" : \";
}
}
Debug.WriteLine(\"\");
Debug.WriteLine(\"Unable to give attention: \" + unableToRead);
Debug.WriteLine(\"-------------------------Impression Constituent!\");
}
Debug.WriteLine(\"Through!\");
projReader.Swan song();
projConn.Deal in();
}
plant(Exception ex)
{
MessageBox.View(ex.ToString());
}
I can apprehend the recital I am essaying to obtain ended using the automation butts that are discovered into Unit, but this is truely a trial in the ass conjointly MS says centrally located their docs that it is not a good suspicion, so I'm trying to be a good citizen together with skirt it.