Importing SQL data

[Hacknwhack]

I am new to VBA, but have done a bunch of VBScript, although not sure if
this will be of any benefit

I am trying to import all project data from a SQL database including start
and finish dates. I do have the mapping of sql fields to project fields
figured out but have no idea where to start.

I want to first:
1. Prompt for a project ID
2. Define the SQL Query and execute
3. Use the resulting recordset to populate the Project fields
4. Format the project gantt as required.

Any info would be a tremedous help

-hack

 

[JackD]

It is not quite as simple as it might seem at first glance.
One would think they could just bring the tasks over, but in a real schedule
the tasks are organized in an outline structure. The tasks have
relationships to other tasks. They have various resources assigned. They
have constraints and different levels of work associated with them. They are
of differing types. They may have calendars which determine when the work
can take place. They may have a WBS or other sorts of outline codes
associated with them. And they have a hundred or so user-defined fields. The
fields can have different names, and different values. On top of that there
is formatting. And baselines. And Timescaled Data. And lions and tigers and
bears.

Rather than jump into coding, I'd start by writing up a set of requirements.
What information do you want to bother with? What are you going to ignore?
Then start with a single task. See if it imports the way you want (it
probably won't and may set a constraint where you don't want it), then try
with two linked tasks. Then try a summary task and it's subtasks.

The real trouble is in your steps 2 and 3. I believe it is necessary to do
multiple queries and imports. But I could be proven wrong.

Sorry if that isn't what you want to hear, but Project is not Excel.

 

[Hacknwhack]

Thanks Jack for the info, however the import requirement is for a much
simpler need.

In this particular example, the reason for the import is to simply display
the information in a gantt chart, something that the original system is
incapable of doing. No scheduling