From: Jan Wieck <JanWieck@Yahoo.com>
To: Faizol Halim <faizol_h@Yahoo.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: export to excel format
Date: Fri, 11 Apr 2003 08:58:39 -0400
Message-ID: <3E96BBFF.EA28AE13@Yahoo.com> (raw)
References: <20030411063503.79822.qmail@web10009.mail.yahoo.com>
Faizol Halim wrote:
>
> hi all,
> first of all, I'm sorry if this is not the right
> place to ask (if so, where should I direct the
> question to?)
> my question:
> is there anyway that I could export some of my tables
> to an excel format..? any module or pointers on how
> this could be done..?
Maybe, but what about "importing" the data directly?
Get the PostgreSQL ODBC driver
http://gborg.postgresql.org/project/psqlodbc/projdisplay.php
and install it on your Windows box. Add the ODBC support functions on
the database side. Make sure the Windows system has access to the
database (pg_hba.conf, username/password). Create a DSN and access the
database directly from Excel.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: JanWieck@Yahoo.com, faizol_h@Yahoo.com
Subject: Re: export to excel format
In-Reply-To: <3E96BBFF.EA28AE13@Yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox