Export MS Project data Access

[aj20]

Hi,
I am new to programming. Can anyone please help me?? Could you please tell me how and where do I have to write macro in order to export the project file data to Access.

Thanks a bunch in advance.

 

[PDQBach]

File | Save As
Change the file type to Microsoft Access Database (*.mdb).
Click on Save and let the Wizard do the work

 

[mbuell]

We did it a little differently. We coded a function in Access to open the project file, export to Excel format, then import to a table in Access. We looked at using an mdb format instead, but we couldn't get Project to save the Project tables as mdb format, whereas we did get that to work (using an export mapping) to an Excel format. If I remember, Project didn't want to give is the data the way we wanted it when we saved to mdb. You may want to play with the methods, depending on what data you want, and how you want to see it.

Our process has been working great for almost a year now. One button processing.

Regards;
Mark

Mark
<O>
_|_

 

[PDQBach]

MBuell: Your way is guaranteed to work but reading between the lines of AJ20's question suggested an absence of "local" (i.e. in his company) technical support with experience in the areas he was exploring.

I had two choices: engage in remote desktop support or give him an opportunity to make some progress so that he would at least have the data available even if additional processing was necessary.

 

[mbuell]

I can see your point. I just thought some additional info might be helpful. Never can tell.

I'm certainly not being critical of your help, if it comes across that way. Just adding to your good advice.

Best to ya

Mark
<O>
_|_

 

[aj20]

Hi All,

I am extracting data from multiple project plans through VB code. All the project plans somehow always store -1 as ProjectID in the database table. How can I differentiate data from one plan with another if the project ID is same for all the plans.

Basically what I do is when I run the VB application, the left list box is filled with all the available project plans. Next the user can select any plan in the right list box and press the extract button. I extract data from Assignment, Task, Resources and AssignmentTimephasedBy Week tables and store in the database. Now the question is if the user extracted a particular file and after some time again extracted the same file, I should not load the data from the same plan twice into the table. There should be a way to delete the old information from that plan and insert the updated plan information into the database. I am not able to find a key by which I can fire a query to delete the old information from the table before inserting new. Could someone please help me urgently.

Many Thanks in advance