Skip site navigation (1) Skip section navigation (2)

Re: export to excel format

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Faizol Halim <faizol_h(at)Yahoo(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: export to excel format
Date: 2003-04-11 12:58:39
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
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

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.


# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to


pgsql-interfaces by date

Next:From: Peter MountDate: 2003-04-11 13:06:36
Subject: Re: export to excel format
Previous:From: Faizol HalimDate: 2003-04-11 06:35:03
Subject: export to excel format

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group