Integrating an Access Query into Project

[Stuart Reicher]

I need to import info from an access query into project. Basically I need
project name, start date and end date for about 50 projects. Is there a way
to do this.

 

[Steve House [MVP]]

What is the end result you're looking for? You have a query that returns
name, start and end dates for 50 projects. Are you trying to incorporate
these as summary tasks in a project file or do you want Project to generate
50 separate project files? Does your query return just the project names or
does it also return the tasks and resources within the project as well?

By the way, regardless of which you're looking for, there's a complication
with having both start and end date - Project allows you to specify one date
but then it always calculates the other - you simply can't specify both
dates for a project. One of its primary functions is to help answer the
question "If we can start on XX date, when will we end?"

 

[Stuart Reicher]

I am looking for a report showing the time lines of each project to help in
scheduling and conflicts. It also will help in budgeting. There are no
resources involved. We manage construction projects. If there is something
else to do this let me know. I couldn't do it using a graph.