Saving data in MS Project 98 to MS Access
Tasks are in the task table, projects are in the project table, assignments
are in the assignment table, resources are in the resource table. Typically
the ****_UID field is the key to the other table (assignments consist of a
resource and a task, both indicated by the id's. You will have to join the
tables if you want the task name and resource name together.
There is a field in the task table that should indicate if the task is a
summary task or not. I haven't dealt with the Proj98 db since 1999, so I
can't give you the exact table or field names, but you should be able to
find them.
I believe that there is a field which indicates the "parent" of each task in
the task table, so joining the table to itself (where task_id = parent_id)
will give you the name of the parent.
You will want to join to the project table if you have more than one project
in your db as well. Project_id should exist in all of the tables that you
wrote about.
--
Please try to keep replies in this group. I do check e-mail, but only
infrequently.
-Jack Dahlgren
+++++++++++++++++++
Hi:
I need to export data from MS-Project 98 to an Access database. I need to
store
the structure of the data in Access, while doing this. I mean, after I
export the
data from Project to Access, I must be able to look at data in Access
database,
and tell the different levels (like Project or Task or Assignment level).
I tried doing the "Save As" and then selecting Access, and storing it *.mdb
format. The problem is I miss out on the hierarchy. Now I'm not sure which
one is
the Project and which one is the assignment or the task.
Any help in this regard is greatly appreciated.
Thanks.
