export from filepro to an excel file

Don Bush don at caffco.com
Tue Mar 14 15:12:16 PST 2006


We just create a macro in excel with a short key to reformat the 
columns and what ever else
we need.  user open the file in excel the press "ALT U"

  At 04:11 PM 3/14/2006, Dennis Malen wrote:
>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
>
>_______________________________________________
>Filepro-list mailing list
>Filepro-list at lists.celestial.com
>http://mailman.celestial.com/mailman/listinfo/filepro-list




More information about the Filepro-list mailing list