On Feb 15, 2011, at 12:25 PM, Carlos Mennens wrote:
> I'm trying to figure out how I can have users in the office connect
> their Microsoft Office 2007 clients to our company database server
> running PostgreSQL 8.4.7. I've configured PostgreSQL to accept
> incoming connections and allow users to login however I read that I
> need to have each client install a MSI pack that allows ODBC drivers
> to talk to the database server. I've installed the ODBC driver from
> the following URL:
>
> The Drivers can be found at:
> PostgreSQL: http://www.postgresql.org/ftp/odbc/versions/msi/
>
>
> I installed it on the machine running Office 2007 but beyond that I
> have no idea how to initialize a connection from Excel or Access to
> the database server. Can anyone please help me figure out how to
> connect?
>
> I have my 'pg_hba.conf' & 'postgresql.conf' files configured perfectly
> to accept incoming SSL connections from my internal network on the
> default port for PostgreSQL.
I googled "connect excel postgresql" and found this:
http://port25.technet.com/videos/research/excelopendbprimer.pdf
which seems to take one through all the steps.
Cheers,
M
