"TK" wrote ...

I thought you might find this interesting.

I wrote a simple select query in Access

"SELECT DISTINCTROW TOP 30500 Products.ProductID,
Products.ProductName, Products.UnitPrice FROM Products;"

Called the query from excel with the connection object,
used CopyFromRecordset to write it into a sheet it took

1.3 sec

Using the same select statement and CopyFromRecordset in excel
to write to a sheet it took

.59 sec

I agree. Using a 60K rows by 100 column recordset, my results we

5.438 secs using CopyFromRecordset
9.250 secs using Application.Transpose(rs.GetRows)

BTW when using I tried with 60K rows by 255 columns it was 14 secs for
CopyFromReocrdset whereas GetRows caused an error, 'Not enough storage
is available to complete this operation', for which I assume the
limitation lies with the Transpose() function.

Have a happy thanksgiving

We don't celebrate it in my country (UK), we go mad at xmas instead
<g. But I'll enjoy the day, thanks, and hope you will too.

Jamie.

--