Using VBA to Call WinSQL - Can it be Done?

[anttor]

Hello all, I'm a bit of a novice when it comes to VBA; I can write some basic code well enough, but I have been unable to find the information I need for the following situation using Microsoft Excel 2007. In a previous job, I know our actuaries had some VBA code that had some SAS references that allowed them to run a query in SAS in the background; they had the queries to run in a Excel named ranges, then had a macro to refer to each named range and run one query after another. The VBA had the SAS Workspace Manager reference. Is there some way to use a similar technique with WinSQL? My end goal is to connect to an ODBC, run some queries, and then have the results pasted into the Excel file which will in turn feed some graphs and charts. I know that there is the option to use Microsoft Query within Excel, but it doesn't appear to meet all of my querying needs in terms of functions. Any insight would be greatly appreciated. Thank you!