Hi,

I am facing a problem with respect to the following task...

I have to port data from 4 recordsets to a single table,

the 3rd and 4th recordsets hold row wise data which had to go into columns in the target table , ie., i need to move partly a row wise data to the column level in the target table.

the target table's structure varies dynamically.

please help me


thanks,
Sasidhar

__________________
thanks,
Sasidhar

Hello,

  You can have loop thru target table fields using

rsTarget.fields.count property and loop thru that and insert data on conditional basis.

. For that one more recordset is needed(temporary)

thank u very much will try and get back to you

thanks,
Sasidhar