Re: PostgreSQL - linked with MS Excel

--- Nefertiti Nefertiti <woymita@xxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match