export to excel 190,000 records

[Plog]

I am new to Access but have a query with 190,000 records but only 5 columns.
I need to create excel reports based on sorted or filtered information.

There are about 20 differing items in the 5th column
There are about 80 differing items in the 4th column
Columns 2 & 3 have times in them (minutes)
Column 1 has 4 different items.

I need to sort initially by the 4th, then the 5th, then the 1st so that I
can then add up the total minutes in columns 2 & 3 by the different groups
and work out %age differences.

I hope this makes sense, any ideas???
Thanks

 

[Jerry Whittle]

What version of Access and Excel? Versions of Excel older than 2007 can not
handle that many records. Versoins of Access older than 2007 can not export
that many records to an xls or xlsx file (but there is a work-around).

 

[J_Goddard via AccessMonster.com]

Hi -

Is there any particular reason why you would want to use Excel? MS Access
can do all the filtering, grouping and sorting you need, and query or report
fields can do most of the calculations. Percentage differences might be a
bit tricky, though - what is it you are trying to do?

John