Excel and ODBC

How to send SQL statement via ODBC using the VBA (by Excel) to the database
(Postgres). Please help

pereyra wrote:
> How to send SQL statement via ODBC using the VBA (by Excel) to the
> database (Postgres). Please help

Here's some general info on ADO

http://www.*****-blog.com/archives/2...ordset-basics/

Depending on what you want to do, you may be interested in the Execute
method.


--
**** Kusleika
MVP-Excel
www.dailydoseofexcel.com

„Dick Kusleika” pisze:

> pereyra wrote:
> > How to send SQL statement via ODBC using the VBA (by Excel) to the
> > database (Postgres). Please help
>
> Here's some general info on ADO
>
> http://www.*****-blog.com/archives/2...ordset-basics/
>
> Depending on what you want to do, you may be interested in the Execute
> method.
>
>
> --
> **** Kusleika
> MVP-Excel
> www.dailydoseofexcel.com
>
>
>
I'm intersted in execute a SQL statement like UPDATE... or INSERT... . I
don't wont to get the results or this statement into the Excel.
I saw this metods but I coudn't find the ODBC driver for Postgres. If you
know a ODBC driver for Postgres I'll be very grateful.

pereyra wrote:
> "**** Kusleika" pisze:
>
>> pereyra wrote:
>>> How to send SQL statement via ODBC using the VBA (by Excel) to the
>>> database (Postgres). Please help
>>
>> Here's some general info on ADO
>>
>> http://www.*****-blog.com/archives/2...ordset-basics/
>>
>> Depending on what you want to do, you may be interested in the
>> Execute method.
>>
>>
> I'm intersted in execute a SQL statement like UPDATE... or INSERT...
> . I don't wont to get the results or this statement into the Excel.
> I saw this metods but I coudn't find the ODBC driver for Postgres. If
> you know a ODBC driver for Postgres I'll be very grateful.

http://gborg.postgresql.org/project/....php?downloads looks
like an ODBC driver for Postgres. If you use the Execute method, you can
execute any sql statement including update and insert.

--
**** Kusleika
MVP-Excel
www.dailydoseofexcel.com