Ho do I Export/Copy a VFP 6.0 DBF with > 20000 recs to XLS?

[Dave1957]

Problems:
1) I have a VFP DBF file with more than 20,000 records that I need to export it to an XLS file that will be emailed to client.
2) Client will only accept file in XLS format and single a workbook.
3) Server does NOT have VFP or Excel software loaded.
4) The process that builds the DBF runs automatically on an independant server using an EXE created from VFP 6.0.
5) Company will NOT upgrade to VFP 8.0, so it has to be done in VFP 6.0.

Currently, the process runs and creates the DBF file and then exports to a SYLK format file. I then manually copy the file to my PC and convert to XLS then copy back to the server, where I run the second half of the job to email to client. I would like to be able to setup the process so it will automatically create the XLS with all 20,000+ records in a single workbook and then email to client without any intervention by me.
Is this possible? Any help would be appreciated.
Thanks,
Dave1957

 

[baltman]

Adapt this:
faq184-4704

 

[Mike Lewis]

Dave,

Have you tried an ordinary COPY TO ... TYPE XL8 command? That doesn't require Excel to be installed, and should handle more than 20,000 rows -- provided of course that the client opens the workbook in a version of Excel that allows that many rows (all recent versions do).

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[TamarGranor]

Actually, Mike, while you can APPEND FROM ... TYPE XL8, COPY TO doesn't support that version. It only goes up to XL5. However, that should be good enough here. It's 64K rows.

Tamar

 

[Stella740pl]

VFP6 doesn't support COPY TO ... TYPE XL8 at all, it just throws you an error. But it does support COPY TO ... TYPE XL5,
and it does copy 64,000 rows - and it is Excel's, not VFP's limitation.

 

[Mike Lewis]

Stella and Tamar,

Thanks for the correction. I should have said XL5 rather than XL8.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk