Stuart McLachlan
stuart at lexacorp.com.pg
Sat May 6 07:35:24 CDT 2006
Correction:
>
> ...'Fill recordset rs with Project table
> ....
> While not rs.eof
> strDevelopers() = split(rs!DeveloperNames,";")
> For lngLoop = 0 to UBound(strDevelopers)
> strSQL = "Insert into tblDevelopers (Project,Developer) Values (" & _
> rs!Project & ",'" & strDevelopers(lngLoop) & "')"
> ......'write new record using the SQL string
> Next
> rs.movenext
> Wend
>
--
Stuart