I use Excel quite a bit using ODBC connections with Access (where queries are
stored) that ultimately ends up querying a MS SQL database -- What I would
like to do is eliminate the "middle guy" in not using Access in between and
would also like to create dynamic queries within Excel's vba environment to
query the MS SQL database directly -- I would also like to create dynamic
queries in vba -- I can handle the dynamic query part of creating a sql query
-- I just don't know how to handle sending the query directly to MS SQL from
VBA.

Any ideas?

I have been successful in creating select queries from a vba environment --
its just trying to do make table queries withing vba --