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