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
