Stupid question but hey its friday Please Someone

[robctech]

Does anyone know of an easier way to append an array
of data to a field rather then a loop.

Situation is I have a recordset with 3 fields...I have an array with 2000 elements in it.

Right now I use the following

For AddThem = lbound(myarray) to ubound(myarray)
   therecordset.AddNew "Field3", myArray(addThem)
next

is there a way to just insert all 2000 elements in one fell swoop?

 

[chiph]

Not really.

You could look at producing a flat file that the SQL Server data transformation service can understand - that is definitely faster (but may not fit with what you're trying to do)

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first