Excel's limit is 65536 rows per spreadsheet. You can find this and other info by going to Excel Help and typing in "specifications".
You could truncate the data to the first 65536 records, then dump records 65537 and up to a different sheet, but that's not a good way to proceed.
Do you have MS Access? It is more much suitable for handling that much data.
[tt]_____
-John
[/tt]Help us help you. Please read FAQ181-2886 before posting.