export to excel 190,000 records

P

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
 
J

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top