Getting data from SQL using VBA in Excel - should I use views with Sum or do the summing via VBA
Posted on 2008-10-09
I am using Excel VBA to get data from SQL tables. I need to sum a large amount of data. Am I better off creating Views in SQL that do the summing and then querying those views or can I just query the table and use a While loop to query the data. I suppose a 3rd option would be to sum the data using the query right in VBA too. So of those three options, which one is "better" and would be faster?