Analysis and Realization of the Advanced Query for EXCEL Data
Debao Dai · Computer Knowledge and Technology · 2009
It is hard for EXCEL itself to repeat the same or similar job for many times in statistical or crossed data operation,however,the composed technology of Visual Basic,ADO,SQL and VBA has been found to be a good way to solve this problem,and it can improve the efficiency of EXCEL data to be dealt with.The precondition of the method is that the flexible SELECT statement in SQL which can realize rapid summarization,composed calculation of the data from one or multi-sheets with support for grouping and sorting.As to be concerned with the data output,the QueryTable object in VBA is use to import the RecordSet data into EXCEL file efficiently.