Can you use SQL in Excel VBA?
Can you use SQL in Excel VBA? Excel SQL Query Using VBA. Using VBA to create your Excel SQL query is not as straight forward as the previous approach, but can still be an extremely useful method depending on your situation. I particularly like that the data is not returned Read more…