export to excel 190,000 records

Discussion in 'Microsoft Access External Data' started by Plog, Feb 17, 2010.

  1. Plog

    Plog Guest

    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
     
    Plog, Feb 17, 2010
    #1
    1. Advertisements

  2. 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).
    --
    Jerry Whittle, Microsoft Access MVP
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

    "Plog" wrote:

    > 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, Feb 17, 2010
    #2
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Dave McDonald

    Export To Excel with more than 65,000 records

    Dave McDonald, Jul 21, 2003, in forum: Microsoft Access External Data
    Replies:
    3
    Views:
    20,824
    Joe Fallon
    Jul 24, 2003
  2. EXPORT EXPORT EXPORT

    , May 11, 2004, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    578
    Douglas J. Steele
    May 12, 2004
  3. >>>>   300.000 ?uro in ......   300.000 ?uro in ..

    >>>> 300.000 ?uro in ...... 300.000 ?uro in ...... <<<<

    >>>> 300.000 ?uro in ...... 300.000 ?uro in .., Aug 23, 2005, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    137
    >>>> 300.000 ?uro in ...... 300.000 ?uro in ..
    Aug 23, 2005
  4. >>>>   300.000 ?uro in ......   300.000 ?uro in ..

    >>>> 300.000 ?uro in ...... 300.000 ?uro in ...... <<<<

    >>>> 300.000 ?uro in ...... 300.000 ?uro in .., Aug 23, 2005, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    152
    >>>> 300.000 ?uro in ...... 300.000 ?uro in ..
    Aug 23, 2005
  5. Guest

    Best way to import 50,000+ records?

    Guest, Jun 23, 2006, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    166
    Guest
    Jun 23, 2006
Loading...

Share This Page