Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL ODBC Connection
Does anyone know of a resource for learning to implement dynamic SQL Queries
with VBA? I have tried a few times to manipulate the SQL string but it seems to be very sensitive and it is slow going figuring out what pieces I am missing. Basically I am looking to develop a method to allow the user to select from a set of "And" statements then concatenate the SQL parts to result into the finished CommandText string. Any suggestions would be appreciated! i.e. '************ With ActiveSheet.QueryTables.Add(Connection:= _ "ODBC;DSN=Database;UID=;PWD=;SERVER=data.com", _ Destination:=Range("A1")) ..CommandText = Array("") ..Name = "Query" '************ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL ODBC Connection | Excel Programming | |||
ODBC Connection | Excel Programming | |||
change and ODBC Connection | Excel Programming | |||
ODBC Connection | Excel Programming | |||
ODBC connection by udl | Excel Programming |