>>>>>>
>>>>>>>>Only copies 16,384 records. Is this a VFP limit or can it be overriden
>>>>>>>>
>>>>>>>
>>>>>>>This is Excel limit.
>>>>>>
>>>>>>Are you sure? I can add rows to the Excel sheet beyond 16384 in the test XL file.
>>>>>
>>>>>It depends on Excel version.
>>>>>Excel 7.0 Help: "Maximum sheet size 16,384 rows by 256 columns"
>>>>
>>>>OK, that may be. I'm running Excel97 SR1. Still, though, that maximum is imposed by VFP in the copy so the workaround has to be in VFP.
>>>
>>>Try EXPORT command.
>>
>>Nope....same problem.
>
>I remember similar thread few months ago, and I cannot neither find it nor remind what was the solution. Probably, it was some OLE automation. Sorry :)

---

Agree to use EXPORT command.

but if you really want to use in Excel Format, here are some suggestions!

a) Type to divide the orignal table and move away some out-dated, just for reference record such as the orders information of three year above...
because most data are quite meaningless at all. Then, you can make a second
opm. table for up to seven years data!
For law, even a/c data that outer than 7 years can be erased !!
So, cleaning rubblish is also important!!

b) Try to divide the same table according to Catego... (^_^ forgot spelling)
e.g. Item start with [A] to [C] put to one file, [D] to [F] ...
it will shorten time on search if really the orderline Do not order other catego... !!

c) afterall, if still fail. do following code:

Export to file1_ type xl5 for recno() < 16384
Export to file16385_ type xl5 for recno() > 16384 and recno() < 32768
....

but if you have huge data, ask if possible don't use Excel to carry!

---

maybe what can I say, SQL is to select the useful info from source....
try out what your boss need and make an alternative way to select what they
want... usually less than 16384 record and everyone feel happy!! ~_^