Populating Project from Recordset

[Hacknwhack]

I have a macro that collects very basic information from a SQL database into
a recordset. The only goal here is to create a Gantt Chart for presentation
value and not functionality, so all I want to do is to simply loop thru my
recordset and create tasks for each item. The recordset also includes the
original and remaining durations, one custom text field and a scheduled
start and end date (as calculated in an external scheduling product).

I have been able to populate 1 task using
SetTaskField Field:="Name", Value:=rsProjData("description")
however this seems to constantly overwrite itself and I have a feeling that
this probably isn't the best way either.

I would greatly appreciate any help I can get here.

Thanks,
-hack

 

[Rod Gill]

Hi,

Record a macro of you manually adding a task. You just need to add a loop
around it to read all task data and you're just about there.