FW: pgsql->ms excel

-----Original Message-----
From: Serkan Bektas [mailto:sbektas@karincaint.com.tr]
Sent: 19 Subat 2002 Sali 15:00
To: Herbert Liechti
Subject: RE: [GENERAL] pgsql->ms excel




You can use Get External Data ==>New Database Query
in MS Excel to get the data directly in to Excel with ODBC link.

You can set the query to "refresh on open".
You can set the query to "don't change cell formats".

I think this is useful too..

Serkan


-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Herbert Liechti
Sent: 19 Subat 2002 Sali 14:44
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pgsql->ms excel


On Tue, 19 Feb 2002 pilsl@goldfisch.at wrote:

 > Is there some ready2use or almostready2use-solution for converting a
 > pgsql-table into a ms-excel .xls-file ?
 >
 > I dont think its a big deal using the appropriate perl-module but if
 > someone already did the work, I dont want to do it again.
 >  If nobody did it : I'll do it and post it here if I succeed.

There is a perl module Spreadsheet-WriteExcel for this purpose. In
combination with the DBI modules it is very easy to create any
excel sheets.

You may grab at the CPAN near you.

Best regards
Herbie

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti                                  http://www.thinx.ch
ThinX networked business services    Adlergasse 5, CH-4500 Solothurn
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly