Updating ODBC query with VBA

I have a sheet with 8 ODBC queries on it, and when i refresh all the data it takes almost a full 2.5 minutes to refresh. Is there a way using VBA to fetch the same data that I need from the server that would be faster?

Thanks,
CodeManCode

If the SQL pulls all the data in 1 batch then no. Unless you can pull smaller batches.

If the SQL is in cells ,pulling 1 cell at a time ,then yes, you can improve by importing all at once, THEN place data in cells.