Timescaled data from MS Project to MS Access
In the Open Standard
Dean DeaconMember for 22 years 3 months
- Created
- 1
- 3
0
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
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
1 reply
Oldest first- 0Mk Tse ·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.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?