export from filepro to an excel file

[Dennis Malen]

I know this topic has been discussed before.

We currently create an export file with:

export multi exp=/tmp/bouncchk.xls r=1 f=1

Even though we we add the extension ".xls" the file that is created is 
really SYLK (Symbolic Link).

We use multi as opposed to comma delimited because if we are transferring a 
social security number that has a leading "0" it chops it off. That does not 
happen with multi. We FTP the file to our server and open the file in excel.

The only problem we have with multi and comma delimited is that if we are 
transferring a number such as "37.50" excel picks up the number as "37.5". 
If we send "37.00" excel shows it as "37".

We know that we can go into excel after the file is created and reformat the 
column as a decimal. Time is money and we don't want to have to do this.

Does anyone know of any way to overcome this problem.

We are on filePro 4.8 (going to 5.0 shortly) and on IBM AIX Unix.

Thanks,

Dennis Malen
516.479.5912