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

Re: PostgreSQL - linked with MS Excel

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Nefertiti Nefertiti <woymita(at)yahoo(dot)fr>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: PostgreSQL - linked with MS Excel
Date: 2005-06-08 15:15:47
Message-ID: 20050608151547.30224.qmail@web20824.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
--- Nefertiti Nefertiti <woymita(at)yahoo(dot)fr> wrote:

> Hello, please help me!!!!
> 
> I'm trying to export some data from PostgreSQL to MS
> Excel.
> Now my solution is to copy data on .CSV format and
> after convert theses files to .XLS format.
> I'm a new user of PosgreSQL and I wan't to know if
> there is a another way to export data from PSQL to
> Excel maybe through ODBC.

ODBC should work for you.  Assuming that you have the
psqlodbc driver installed, and that you have set up a
DSN for the PostgreSQL database, then just go through
"Data", "Import external data", "New database query"
(I don't know what those would be in French, sorry). 
Just follow the prompts from there.

MS Query, which Excel uses to get the data, has some
annoying limitations in its functionality, so you may
find that it will not do what you want.  In that case,
a more robust solution would be to write some VBA code
that fetches the data for you (ADO is a good choice
for this).  There are plenty of examples in the MS
Knowledge Base.

The code solution may be overkill, depending on how
often you want to do this import.  If the above
choices are not desirable, PostgreSQL -> .csv -> Excel
may be your best alternative after all.

> Are you able to help me? Would you have enough
> patience?
> Any information will be very important?
>  
> PS: I have WinXP + PostgerSQL 8.0.2  + Ms Excel.
> 
> Thanks, so much,
> Weymy.
> 
> 
> 		
> ---------------------------------
>  Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de
> stockage pour vos mails, photos et vidéos !
> Créez votre Yahoo! Mail  



		
__________________________________ 
Discover Yahoo! 
Get on-the-go sports scores, stock quotes, news and more. Check it out! 
http://discover.yahoo.com/mobile.html

In response to

pgsql-odbc by date

Next:From: George WeaverDate: 2005-06-08 15:44:07
Subject: Re: PostgreSQL - linked with MS Excel
Previous:From: Nefertiti NefertitiDate: 2005-06-08 14:44:50
Subject: PostgreSQL - linked with MS Excel

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