Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Timescaled data from MS Project to MS Access

1 reply [Last post]
Tue, 2004-07-06 06:30
Dean Deacon
User offline. Last seen 20 years 6 weeks ago. Offline
Joined: 6 Jul 2004
Posts: 3
Groups: None
I am having difficulty extracting timescaled data to MS Access from Project.

I would like to extract a date range i.e. the next 4 weeks, into MS Access, and display the work for each task by week.

The only way I can currently extract timescaled data is to use the macro that dumps it to Excel. This is fine, however there is no way to include custom fields - I need a number of these for analysing purposes.

Any help would be very much appreciated.

Regards

Dean
Top

Replies

Sat, 2004-07-10 09:29
#1
MK TSE
User offline. Last seen 4 years 10 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
This knowledgebase document from Microsoft may help http://support.microsoft.com/default.aspx?scid=kb;en-us;151555&Product=PRJ. The document mentioned how to export Project data into Access directly.
Top