Without getting fancy, I sidestepped the problem for a single instance by outputting the file in CSV (Comma Separated Value) comma delimited text format. Any competent Excel user should know how to import it, and if not, it is a fairly easy matter to walk them through it. Just be sure the total number of records doesn't exceed Excel's limits. Also be sure the database has no quote (") characters in any of the field data. That character is used as the text delimiter, and an extra one will throw off the correspondence. (My table used the " character as an 'inch' symbol for a measurement. For a while, we couldn't figure out why many of the fields were messed up.)



Neil Preston


>Hi,
>When I use the COPY TO ... TYPE XLS, it seems that only the first 7000+ records of the table copy. I know there was a limit in Fox 2.6. Is there a record limit in VFP 6.0?
>Thanks,
>John