Welcome to SPN

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

Sign Up Now!

Export over 65k records to Excel

Discussion in 'Information Technology' started by Dan, Jul 28, 2006.

  1. Dan

    Dan
    Expand Collapse
    Guest

    Hello,
    I need to export a query out of Access into Excel, but the query has more
    than 65,000 records. Is there an easy way to export the data to Excel and
    tell Access to create multiple sheets of data? I can always export the
    query to a text file and copy/paste several times, but I would rather avoid
    that if possible.

    Thanks in advance,
    Dan
     
  2. Loading...

    Similar Threads Forum Date
    World Polish exports of meat for Jews, Muslims in limbo Breaking News May 16, 2013
    India's Leading Export: CEO's Inspirational Stories Jul 23, 2011
    India India's Latest Export: Rent-a-Womb Breaking News Dec 22, 2010
    Sikh News Banning of export of milk powder will be a retrogade step, says Punjab MP Gujral (New Breaking News Jun 4, 2008
    Sikh News Punjab's Steel Producers Seek Ban On Iron Ore Export (Nasdaq) Breaking News Feb 26, 2008

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Maybe not what you are looking for but you can use a query to select TOP
    64999 for export then update a flag field for the same 64999.

    Next query has criteria to eliminate those flagged.

    "Dan" wrote:

    > Hello,
    > I need to export a query out of Access into Excel, but the query has more
    > than 65,000 records. Is there an easy way to export the data to Excel and
    > tell Access to create multiple sheets of data? I can always export the
    > query to a text file and copy/paste several times, but I would rather avoid
    > that if possible.
    >
    > Thanks in advance,
    > Dan
    >
    >
    >
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Dan wrote:
    > Hello,
    > I need to export a query out of Access into Excel, but the query has
    > more than 65,000 records. Is there an easy way to export the data to
    > Excel and tell Access to create multiple sheets of data? I can
    > always export the query to a text file and copy/paste several times,
    > but I would rather avoid that if possible.
    >
    > Thanks in advance,
    > Dan


    Wait for the next version of Excel?? It eliminates that limit.

    --
    Joseph Meehan

    Dia duit
     

Share This Page