Re: export to excel format

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: export to excel format
Дата
Msg-id 3E96BBFF.EA28AE13@Yahoo.com
обсуждение исходный текст
Ответ на export to excel format  (Faizol Halim <faizol_h@yahoo.com>)
Ответы Re: export to excel format
Список 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
   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 #



В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Faizol Halim
Дата:
Сообщение: export to excel format
Следующее
От: Peter Mount
Дата:
Сообщение: Re: export to excel format