Hey Bruce.

I think I tried some of the code and it worked pretty well, but if it is too slow, is there a better method? I wondered about the _datatoclip stuff because I thought it would blow up on null values and had a record limit. I thought I had run into some of this with version 5, but 6 was happy as a clam. I guess if I wasn't so lazy (or busy) I would test all of this and find out for sure.

Anyway, if you've come across a more efficient way I'd be interested in seeing it. We dump a lot of stuff in Excel around here....

Thanks

Scott


>>Ivo,
>>
>>This has been discussed some in previous threads. If you want to copy more than the 16,000 records you need to copy to Excel97 format. But, the copy to command does not support Excel 97.
>>
>>If you go back to 5/4/99 and view the Excel97 non-support continues thread, you will find a solution using objects discussed by Christof Lange and Bruce Campbell.
>
>Hey, and here I am :) The reason I didn't mention this earlier, though, is that I think that "paste" method may have trouble with a "large" number of records. It's kind of slow even with small tables. It may be worth a try, however...