Re: Write to postgreSQL via ODBC? - Mailing list pgsql-general

Rudolf Potucek wrote:
>
> I've got the postgres ODBC driver installed and can connect to it from
> MS Excel 97. However it seems I can only execute queries (read data) but
> not save data. Is that a limitation of Excel or of the ODBC approach?

    When you set up your DSN on the Windows box, did you uncheck
the box in Advanced Options named "ReadOnly (Default)" ? For some
reason, the PostgreSQL ODBC driver defaults to only being able to do
queries.

    There's some useful information about all this in the
PostgreSQL FAQ at:

http://www.postgresql.org/users-lounge/docs/faq.html