SQL ODBC Connection

[Bythsx-Addagio]

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"
'************

 

[Dick Kusleika]

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!

BA: If you find something, let us know. In the meantime, just be very
careful.

Sometimes I'll open up Access and create the query in there, then look at
the SQL.