MS Access RecordSets
Posted on 2014-10-30
I'm using Access 2010 as a frontend to a remote SQL Server. the tables from SQL Server are linked. I'm trying to output data to Excel. Getting it to Excel is not the problem but the fact that its requires the data coming from SQL Server be chopped up in many different ways is... The process is for users to select records that will be exported into and excel report. It could be 1 record or 20k records... I have a form that displays the selected records and a button "Export" that starts the process of creating the multi-tabbed Excel. Each tab of the excel xls requires various filtering and summing and logic to be applied to the selected data set. It's taking way to long to create the file and I believe its due to having to run a number of queries on the same data on the server over and over again.
My question is this... Seeing that I have the selected data is sitting in a form grid can I not use that data to perform all the filtering and summing rather than go back to the server 15 times?
If so, I'm trying to figure out how I would do that.