>HI,
>I have queries that may contain 100-500k of rows. I want to export them in Excel. I tried COPY TO...TYPE XL5. It only copy 16383 rows. I know that Excel is able to hold more than that. Is there another solution for it ? Ole automation surely ?
>
>Thank you,
>Christian Cote
create a .dbf and open that in Excel and save as .XLS. That's the fastest, but 500,000 rows in Excel is a bit exessive ???
row by row automation will be slow!

Peter