SQL in the VBA for Excel

[DaveMac]

Need help running SQL statement in excel.

Not sure where to begin but here is where I am.

I made an ODBC connection to an AS/400 DB

I have an SQL statement that when run in WIN_SQL runs fine.

I now need to add a text_box or cell that allows users to enter data and then click or something to run the query with that data as the where

So does anyone have a sample of the code to call the connection?
And then an example of how to pass the value?

Thanks!

 

[SkipVought]

I have not idea if this is a good reference, but Google returned

http://www.sqlthing.com/book.html

among other links.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}