Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

splitting a large access table to export to excel

Discussion in 'Information Technology' started by Jma000@gmail.com, Jul 28, 2006.

  1. Jma000@gmail.com

    Jma000@gmail.com
    Expand Collapse
    Guest

    I have 100,000 records and need to export the table to excel. excel
    only handles 65,000 or so. I was able to export the 65,000. How do I
    export the remaining 35,000? Is there a query that can pull the
    remaining 35,000 into a table?

    Copy the last 35,000 takes too long.

    Thanks.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Largest Sikh Temple In Lower North Island Opens Its Doors - Stuff.co.nz Breaking News Sep 25, 2016
    Canada First Turban Day observed in Toronto, draws large crowd Breaking News Apr 1, 2014
    Sikh Coalition America's Largest Police Force Trained by the Sikh Coalition Sikh Organisations Jan 13, 2014
    Nature More than three quarters of large carnivores now in decline Breaking News Jan 12, 2014
    Malaysia Malaysia's Largest Interfaith Group Warns It Will Take Lawsuits to the United Nations Breaking News Aug 11, 2013

  3. SusanV

    SusanV
    Expand Collapse
    Guest

    Hi Jma,

    If you use TransferSpreadsheet rather than OutputTo you can define
    worksheets, and export the remaining records to a second sheet in the same
    workbook. You could either break the table up using queries and export
    those, or use a loop to count each record as it's written to Excel, and when
    you hit the limit for the first sheet (65535), stop that DoCmd action and
    begin another to write to a different sheet in the same file.


    --
    hth,
    SusanV



    <Jma000@gmail.com> wrote in message
    news:1149074733.091069.55730@g10g2000cwb.googlegroups.com...
    >I have 100,000 records and need to export the table to excel. excel
    > only handles 65,000 or so. I was able to export the 65,000. How do I
    > export the remaining 35,000? Is there a query that can pull the
    > remaining 35,000 into a table?
    >
    > Copy the last 35,000 takes too long.
    >
    > Thanks.
    >
    >
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Jma000@gmail.com wrote:
    > I have 100,000 records and need to export the table to excel. excel
    > only handles 65,000 or so. I was able to export the 65,000. How do I
    > export the remaining 35,000? Is there a query that can pull the
    > remaining 35,000 into a table?
    >
    > Copy the last 35,000 takes too long.
    >
    > Thanks.


    Can you wait until the next version of Excel comes out? :) It will
    handle over 100,000 records.

    I suggest that you can add (if you don't already have) an autonumber
    field and then use a query to select the records you want for each export.
    Note: normally I would now recommend autonumber for this as it tends to
    leave gaps etc, but for this use and for one use, it should work fine.

    --
    Joseph Meehan

    Dia duit
     

Share This Page