Thread: Excel and ODBC
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
pereyra pereyra is offline
external usenet poster
 
Posts: 2
Default Excel and ODBC



€˛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.dicks-blog.com/archives/2...ordset-basics/

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


--
Dick 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.