From: Penguin P. <pen...@gm...> - 2007-03-02 06:23:02
|
Message: 27 Date: Thu, 1 Mar 2007 12:43:25 -0500 (EST) From: ma...@hu... Subject: Re: [SL] Output reports to csv To: sql...@li... Cc: sql...@li... Message-ID: <297...@bi...> Content-Type: text/plain; charset=iso-8859-1 > My bookkeeper wants to be able to crunch some numbers from my SQL Ledger > database in a spreadsheet. Is there any established way to output reports > to a csv file or something similar? What I do is highlight the HTML in the Firefox, Ctrl-C, then in Excel say "Paste Special" and then "Text". It might work with OpenOffice as well. m I can confirm it does in OpenOffice, You Paste though in unformatted text or it fills your spreadsheet with (I think you call them) URL links to Sql-Ledger (that in itself has uses in presentations and updating prices etc..) Tim |