Computer arithmetic

Bill Campbell bill at celestial.com
Mon Jun 17 10:04:50 PDT 2013


On Sun, Jun 16, 2013, Scott Walker wrote:
>JP,
>
>Thanks for the info.  I've been fighting getting it correct (exporting data
>from fp & importing in Excel) for a while and every trick helps.

I fought this importing data into the LibreOffice/OpenOffice.org
spreadsheets from my accounting application, where the spread
sheet program would do odd interpretations of data type
regardless of my quoting.

My solution was to do the import in two steps, first into a MySQL
or Postgresql database, then import from that into LibreOffice.
Unfortunately, the last time I looked, Excel didn't have the
ability to connect to real SQL databases.

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

The Democrats are the party that says government will make you
smarter, taller, richer, and remove the crabgrass on your lawn.
The Republicans are the party that says government doesn't work
and then they get elected and prove it. -- P.J. O'Rourke


More information about the Filepro-list mailing list