In comp.databases.ms-sqlserver Craig Orsinger <cjorsinger@earthlink_net.invalid> wrote:
: 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.
I did. I subsequently tried this with Access and I can actually create
new tables that way ... now I just have to figure out how to do an UPDATE
instead ...
Thx,
Rudolf