DBF

[GCC Consulting]

> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com 
> [mailto:filepro-list-bounces at lists.celestial.com] On Behalf 
> Of Linda Gray
> Sent: Tuesday, October 12, 2004 9:40 PM
> To: filepro-list at lists.celestial.com
> Subject: DBF
> 
> Hello,
> 
> Does anyone know how to create dbf files from filePro, or 
> from a csv file created from filePro export command?
> 
> Thanks,
> Linda
> 
> 
-------------------------------------
For native filePro 5.0

Without full knowledge of what your requirements are, you can create a csv file
by using:

Export word foobar=c:\temp\filename.csv

Then continue with the export of the fields you need from the records selected.

If you want field headings, you could then do
If: @rs = "1"
Then: Gosub do_head

This will export the field headings.  Just remember to do a write before the
return to export the field values.

Once all the selected records have been exported, you can open the file in excel
and the do a "save as" a DBF file.

If this process is to be run often, you can create a menu script which runs the
export and the starts Excel with the file just created.

@echo off
\fp\rreport foobar -f export_csv -v sel_csv
Start excel c:\temp\filename.csv

Again this is for a Windows based system.

I am using this procedure at a client's site where they need to send a customer
some Excel files once a month. They don't need to create a DBF file.

Richard Kreiss
GCC Consulting