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