Relative Content

Tag Archive for sqlsql-serverexcelvbavba7

Passing SQL query and appending stored procedure parameter with vba

I am looking to import a simple SQL report directly into excel with VBA, and I am unsure whether to split the code into three separate the VBA sub into three distinct parts due to a combination of creating temporary table/appending parameter and running stored procedure/querying temporary table. I have queried data from the server in the past, but do not want to attempt this one until I get some input.