[VBA] Import only some data from Access to Excel

Hi! I have an Access DB and I want to import a table (with 150.000 rows) into Excel.
This is an example of my table:

Col1 Col2
A value1
A value2
B value3
C value4
A value5
B value6

I need to select all "A" values, make some operations, and then put the result in a Excel cell. Then select all "B" values, make some operations, and then put the result in another cell, and so on...
The problem is that I can't import all the table into Excel because it's too large...is there a method to process first all "A" values, then all "B" values to do my operations? The records in Column1 are many (A,B,C,...Z) and unknown.

Thanks,
PAOLO

you can create a recordset from the table where col1 = 'A'