Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel and ODBC
How to send SQL statement via ODBC using the VBA (by Excel) to the database
(Postgres). Please help :( |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel and ODBC
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel and ODBC
pereyra wrote:
"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. 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. -- Dick Kusleika MVP-Excel www.dailydoseofexcel.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you set the default ODBC for MS Excel to use | Excel Discussion (Misc queries) | |||
Open ODBC in Excel | Excel Programming | |||
Get SQL data to Excel without ODBC | Excel Programming | |||
using odbc in excel | Excel Programming | |||
EXCEL AND ODBC AND QUERY | Excel Programming |