Re: Write to postgreSQL via ODBC?

Neither, I would think. The most probable cause is
that your driver is configured for read only access.

Open the ODBC Administration application. (I think
it's at C:\WINDOWS\SYSTEM\ODBCAD32.EXE). Select your
PostgreSQL driver and click on the configure button.

A window will popup with various configuration
options. Under Options(Advanced), there should be a
button labelled "DataSource". Click on the DataSource
button and look for a check box labelled "ReadOnly".
Make sure that "ReadOnly" is NOT checked.

Perform these steps for all PostgreSQL connections
that you have created.

I hope this helps,

Andrew Gould

--- Rudolf Potucek <potucek(at)acs1(dot)acs(dot)ucalgary(dot)ca>
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?
>
> Rudolf
>

__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/