export from filepro to an excel file

[Dennis Malen]

Thanks Bill,

We're starting to look at mysql now.

Dennis
----- Original Message ----- 
From: "Bill Campbell" <bill at celestial.com>
To: "filePro" <filepro-list at lists.celestial.com>
Sent: Tuesday, March 14, 2006 5:49 PM
Subject: Re: export from filepro to an excel file


> 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
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>