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

On Fri, 20 Feb 2009 08:33:00 -0800, Bythsx-Addagio
wrote:

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.
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com