I'm trying to Run an database query from Excel using an Access database. I
can get the values returned in to Excel, that's not a problem. The results
details sales by Location, by product by date. My problem is that the data
is to big to fit within Excel (an its only one months worth of data).

As I wish to use Excel, how can I edit the query within Excel so that the
data that is returned is by Location, by Product, within the overall dates
that I originally selected i.e. I don't need to know that I sold 4 Widgets
on the 1st, 10 on the 2nd etc, only that Location A sold 55 within the range
I selected.

I was told before that there is a download needed from Microsoft

Thanks