Forum Discussion
Uploading/Data Mapping Recurring Task Information for MS Project
I would like to upload a number of recurring tasks into MS Project. How/where do I find the field names associated with recurring tasks? For example: recurring pattern, number of occurrences, etc.
11 Replies
- Jeff --
Pardon me for bumping into this conversation, as John has already given you some sage advice. My only advice to you would be this: If you know the name of the recurring task, you know the Start date of the first occurrence, and you know how many occurrences you need, I think it would be simpler to manually create your recurring tasks. Just a thought. Hope this helps. - Jeff_Herbert,
First of all, what version of Project are you using?
The only way I know to upload that kind of information is with VBA. What application has the recurring task information that you want to upload?
John- Hello John, I'm using MS Project Professional Online Desktop. I have an MS Access Database of Equipment and associated tasks (recurring preventative maintenance requirements). From Access I can generate a list of tasks with the necessary fields as a table to export that I could then upload to Project. I have Task Name, Duration, Resource information, etc., and I have how often the task needs to recure (daily, weekly, monthly, etc.). I want to use project to estimate resource loading for maintenance over a multi year timeframe. I assume there must be defined field names in project that would accept the data needed to generate the recurring tasks. Does this make sense?
- Jeff_Herbert,
Yes, it does make sense.
I haven't worked with an import from Access for several years, it was done using SQL. However, unless there is some avenue through the Project database tables, Project can only import basic fields such as Task Name, Duration, and Resource information. There is no way to directly import recurrence information but it could be done with VBA.
John
