>I am trying to copy 60,000 records into an excel worksheet by OLE automation. I have vfp 6.0 sp4 and Office 2000. I used the copy to command with type XLS to create the excel file. The worksheet only contains 16,384 rows. How can i get the worksheet to contain 65,000 rows? Thanks in advance.

This is due to a limitation of the XL5 format. Excel 2000 technically should be able to handle more, but VFP won't be able to export to that format. So, what to do? Several things come to mind:

1. Using COM Automation, fill the spreadsheet with a SCAN...ENDSCAN loop. Downside: probably would be slow.

2. Export to several worksheets, then use COM Automation to stich them together into one big sheet.

3. I recall that there's an ODBC driver for Excel, so that might work. I've never used it, and I know nothing about it however.