the more you can let Excel/VBA do with a single command, usually the better
off you are. I would look at copyfromrecordset. If that isn't an option,
I put assign the variant to the range. My last choice would be one cell at
a time.

--
Regards,
Tom Ogilvy

"Amar" wrote in message
...
Hi,

Thanks for the overwhelming response to my post. What I necessarily plan
to do is to pick the data from oracle db using recordset, then using the
getRows I will be able to dump all the data into a variant array. Basically
I will be using inner joins to get all the data from various tables. This
variant array can then be used to display in a particular format in excel.
Is this method feasible or should I write individual cells through looping
of recordset fields and records?

Thanks again for replying to the post,

Amar