Mass Load Data

[devonknows]

Hi, the problem im having is i have a multitude of tables with many collums but at the minute im using collections to temp store the data whilst the section of the application is loaded but for my first table there are like 8 columns alone and its a bit unpractical to have 8 different collections for each column.

Also i have to tried multi dimensional arrays but with no success as i cant sucessfully re-dim the array with the count of records stored in the Recordset from the sql query.

Any help would be appreciated

Devon

[techgnome]

why are you storing each col in it's own collection? Use the recordset... that's what it is for...

-tg

[devonknows]

What, just keep all the information on the Recordset without having to store it any other kind of vaar ?

[techgnome]

yup. the recordset IS your var.... typically that's how it's done, create a recordset, fill it, then edit it .... you don't need to offload it to anything else... keeps all your rows together and in synch.

-tg