I must agree that I love using OLE Automation for writing any data at all to excel due to the control it gives you. However, on your point, excel only allows 65,536 rows so if COPY TO limits you to 65,000 you really haven't lost anything.
Paul A. Busbey
Victoria Insurance