export from filepro to an excel file

Bill Campbell bill at celestial.com
Tue Mar 14 14:49:07 PST 2006


On Tue, Mar 14, 2006, Walter Vaughan wrote:
>Dennis Malen wrote:
>
>>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.
>
>Then flip the problem around. Have your spreadsheet request the information 
>for preformatted cells rather than pushing the data.

The last time I dealt with this type of problem it was exporting data from
our accounting system to spreadsheets (OpenPKG.org mostly although I played
with M$-Excel in Office 2004 for Mac some as well).  I fought with it a
fair bit before deciding there Had to Be a Better Way(tm).

Rather than deal with with the import problems, my final solution was to
create a simple mysql table with the proper columns, insert the data into
the mysql with a script on the SCO OpenServer box, the use OpenPKG's data
sources to import into the spreadsheet.

I create a tab-delimited file then run this script:

use xferchecks;
delete from csllc;
LOAD DATA INFILE "/tmp/xferfile.sql" REPLACE INTO TABLE csllc;

I don't know much about Excel so I don't know its capabilities in
interfacing with databases.  I do know that I demonstrated OpenOffice.org's
spreadsheet at a local Apple OS X users group office applications SIG, and
the people who were using Microsoft Office didn't think they could do that.

Presumably one could do much the same thing with FilePro, given a proper
ODBC or JDBC interface to the FP server.

Bill
--
INTERNET:   bill at Celestial.COM  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676

``The best we can hope for concerning the people at large is that they be
properly armed.''
        -- Alexander Hamilton, The Federalist Papers at 184-188


More information about the Filepro-list mailing list