Project database--Need the Experts

[Realgains]

Hello:
What alternative way can I pull my project data from the files while I am
waiting for the sql backend to be made accessible? I have several projects
uploaded to server and I would like to use the data in an access mdb. Who
knows where the basic task data (as would be exported using a map) is in the
table schema? I have the code to export to excel, and kinow how to save as
..mdb. Figuring out the the tables is time consuming. Just want the basic
task data:
name, start, finish,pred, dur, notes, some enterprise custom text and number
fields, % complete, and resource names, ID, UID.

 

[Rod Gill]

Hi,

Search for the projdb.htm file in one of Project's program folders (or the
CD). It has a full description of the database schema.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[Realgains]

Hi Rod:
Thanks. If you have a short moment:
THis is my plan of attack; only have a bit of time to do it.
Create schedules and upload to server
Save one as an mdb
Via a module in access mdb, append others to the mdb

Question: what is needed to pull the data from the backend? As I stated
before, the crew won't allow me to just connect to the SQL tables from within
my .mdb--but I may get them to allow me to pull the data into my .mdb as an
interim solution. Otherwise, i will have to save the plans as .mpp's and
then run the append module.

I also need to be able to delete project tasks and add them into the same
plan but at a different spot in the schedule (under different summary task
for example). Can you point me to some code for this?

I'm still begging the guys for the prjdb.htm file--not on the Project 2003
Pro CD, andyway.

REALLY appreciate your contributions to this site...