>> Nope, ADO is available to Excel97 too.
>> Cetin
>
>I have other other solution working well as described in my other thread, however, I might migrate to ADO in the future.
>
>Do you think the performance using ADO will match bringing in 6 million values into Excel as a .CSV file (which is very fast)?
>
>Thanks,
>Jeff
I don't know, never tried with 6 million values. But should be, with over 3 million values it takes few secs on my Athlon 650, 192Mb system.
.CSV has the advantage of being a natively recognized format in Excel. If you can do with .csv than use .csv.
Cetin