Re: PostgreSQL with MS Query?
От | Patrick Hatcher |
---|---|
Тема | Re: PostgreSQL with MS Query? |
Дата | |
Msg-id | OFD34A9CD9.B16A0E94-ON88256DCC.0061D067-88256DCC.00631558@fds.com обсуждение исходный текст |
Ответ на | PostgreSQL with MS Query? (Grant Rutherford <grutherford@iders.ca>) |
Ответы |
Re: PostgreSQL with MS Query?
|
Список | pgsql-general |
I'll assume you are on a Windows box. The answer is yes, you can use Excel to pull back data from a Pg database on a Linux box. If you are planning to use MS Query and If you don't have MS Query installed, you will need to install from the disk. You can download the Pg ODBC driver from the Pg site. Just click on the download link, select your country, and then navigate to the ODBC/Versions folder. You'll want to download the 7.03.02 version as this is the newest. Then create the DSN - do a Google search on how to do this if you don't know how. Then fire up Excel and from the menu select Data, Get External Data, New Database Query. Follow the wizard from there. hth Patrick ***You wrote**** Hi there, I'm trying to access my postgreSQL database using Excel (through MS Query). I've been reading a bit about ODBC and I'm pretty sure that this is required. Is there a way to see if this is set up already? Am I on the right track? The database server is running redhat linux. Any help would be appreciated... Thanks, Grant
В списке pgsql-general по дате отправления: