It should work, but you could post your question on pgsql-odbc and get
an answer from someone who has more experience with Excel and PostgreSQL
via the ODBC driver.
Bob Pawley wrote:
Thanks
Does one version of ODBC work for all versions of Excel and Postgresql.
I am wanting to transfer one or two tables from Excel and manipulate the
information in Postgresql then transfer the results back to Excel as a
single table.
I am using Excel 2000 and PostgreSql 8.1.
Bob
----- Original Message ----- From: "David Gardner" <david@xxxxxxxxxxxxx>
To: "Postgresql" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Tuesday, June 19, 2007 4:56 PM
Subject: Re: [GENERAL] Excell
Agreed ODBC is the way to go, depending on what you are doing, Access
may be helpfull as an intermediate step.
Joshua D. Drake wrote:
Bob Pawley wrote:
Hi All
Is there a fast and easy method of transferring information between
MS Excel and PostgreSQL??
odbc?
Joshua D. Drake
Bob Pawley
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
--
David Gardner
