Jamie:

I agree and that was my initial suggestion but the O.P.
immediately dismissed it stating they were working with
600,000 rows and I dont know what an Access row is.
Obviously we dont want to start the selection process in
a program thats whole purpose in life is to store and
analysis data.

Good Luck
TK



"Jamie Collins" wrote:

"TK" wrote ...

Hi Jamie:
Always nice to here from you.

“Can you do any manipulation using SQL to reduce the number of rows”

Well a couple ideas come to mind i.e.
Where
Distinct
Group
Join
Having
Ordered BY
Top
Sub queries


Perhaps I should have said:

The OP should review their SQL in case it is possible to reduce the
number of rows being returned to Excel. If the OP posted their SQL
code, example data and desired results, I'm sure they would get some
useful suggestions here.

Jamie.

--