Re: PostgreSQL - linked with MS Excel
| От | George Weaver |
|---|---|
| Тема | Re: PostgreSQL - linked with MS Excel |
| Дата | |
| Msg-id | 005001c56c40$eba40970$6400a8c0@Dell4500 обсуждение исходный текст |
| Ответ на | PostgreSQL - linked with MS Excel (Nefertiti Nefertiti <woymita@yahoo.fr>) |
| Ответы |
pgsql-odbc problem in Windows 9x
|
| Список | pgsql-odbc |
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 NefertitiSent: Wednesday, June 08, 2005 9:44 AMSubject: [ODBC] PostgreSQL - linked with MS ExcelHello, 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
В списке pgsql-odbc по дате отправления: