Re: PostgreSQL - linked with MS Excel

Hi Weymy,

You can link directly to your PostgreSQL database from Excel, and open PostgeSQL tables directly in Excel.

You can do this by creating a DSN and .udl file (http://archives.postgresql.org/pgsql-odbc/2004-12/msg00056.php).

Once you have created the udl file, open Excel and choose File - Open. Navigate to the directory where you created the udl file. in the file type selector box in the open file dialog select All Data Sources. You should see the udl file in the file selection pane. Select the udl file and click on Open. You should be presented with a list of your database tables. If you choose a table, it will be open as a new worksheet in Excel.

HTH.
George
----- Original Message -----
From: Nefertiti Nefertiti
To: pgsql-odbc(at)postgresql(dot)org
Sent: Wednesday, June 08, 2005 9:44 AM
Subject: [ODBC] PostgreSQL - linked with MS Excel

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.
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