Welcome to SPN

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

Sign Up Now!

65,000 record limitation on copy or export to Excel?

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

  1. Bruce

    Bruce
    Expand Collapse
    Guest

    Trying to move about 85,000 rows of data to Excel (now that Excel has approx
    1 million rows) and cannot copy and paste due to clipboard limitations; also
    get the same error message regarding 65,000 record limit when attempting to
    export to Excel.
     
  2. Loading...


  3. Nick Coe \(UK\)

    Nick Coe \(UK\)
    Expand Collapse
    Guest

    Why not try linking the Excel sheet into your Access
    database as a table using Get External Data then stuff it
    with data using an Access append query from your existing
    table. I don't know whether you'd hit limits again but must
    be worth a try.

    --
    Nick Coe (UK)
    http://www.alphacos.co.uk/ AccHelp is now Free
    http://www.mrcomputersltd.com/ Repairs Upgrades

    In news:18DF6E15-1029-49C5-A365-5183BA4607B7@microsoft.com,
    Bruce typed:
    > Trying to move about 85,000 rows of data to Excel (now
    > that
    > Excel has approx 1 million rows) and cannot copy and paste
    > due
    > to clipboard limitations; also get the same error message
    > regarding 65,000 record limit when attempting to export to
    > Excel.
     
  4. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    You can't update linked Excel tables anymore, Nick, since Microsoft lost the
    lawsuit.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Nick Coe (UK)" <classicnickNOSPAMAT@MASPON.yahooDOTcom> wrote in message
    news:eYmrpkOoGHA.4340@TK2MSFTNGP05.phx.gbl...
    > Why not try linking the Excel sheet into your Access
    > database as a table using Get External Data then stuff it
    > with data using an Access append query from your existing
    > table. I don't know whether you'd hit limits again but must
    > be worth a try.
    >
    > --
    > Nick Coe (UK)
    > http://www.alphacos.co.uk/ AccHelp is now Free
    > http://www.mrcomputersltd.com/ Repairs Upgrades
    >
    > In news:18DF6E15-1029-49C5-A365-5183BA4607B7@microsoft.com,
    > Bruce typed:
    > > Trying to move about 85,000 rows of data to Excel (now
    > > that
    > > Excel has approx 1 million rows) and cannot copy and paste
    > > due
    > > to clipboard limitations; also get the same error message
    > > regarding 65,000 record limit when attempting to export to
    > > Excel.

    >
    >
     
  5. Nick Coe \(UK\)

    Nick Coe \(UK\)
    Expand Collapse
    Guest

    Oh. I'd forgotten about that.

    Thanks Doug, owe you yet another beer... :)

    --
    Nick Coe (UK)
    http://www.alphacos.co.uk/ AccHelp is now Free
    http://www.mrcomputersltd.com/ Repairs Upgrades

    In news:%23g5ENoOoGHA.4616@TK2MSFTNGP05.phx.gbl,
    Douglas J Steele typed:
    > You can't update linked Excel tables anymore, Nick, since
    > Microsoft lost the lawsuit.
    >
    >
    > "Nick Coe (UK)" <classicnickNOSPAMAT@MASPON.yahooDOTcom>
    > wrote
    > in message news:eYmrpkOoGHA.4340@TK2MSFTNGP05.phx.gbl...
    >> Why not try linking the Excel sheet into your Access
    >> database as a table using Get External Data then stuff it
    >> with data using an Access append query from your existing
    >> table. I don't know whether you'd hit limits again but
    >> must
    >> be worth a try.
    >>
    >> --
    >> Nick Coe (UK)
    >> http://www.alphacos.co.uk/ AccHelp is now Free
    >> http://www.mrcomputersltd.com/ Repairs Upgrades
    >>
    >> In
    >> news:18DF6E15-1029-49C5-A365-5183BA4607B7@microsoft.com,
    >> Bruce typed:
    >>> Trying to move about 85,000 rows of data to Excel (now
    >>> that
    >>> Excel has approx 1 million rows) and cannot copy and
    >>> paste
    >>> due
    >>> to clipboard limitations; also get the same error
    >>> message
    >>> regarding 65,000 record limit when attempting to export
    >>> to
    >>> Excel.
     
  6. Nick Coe \(UK\)

    Nick Coe \(UK\)
    Expand Collapse
    Guest

    Doug having reminded me about the linked worksheet update
    limitation the only other thing I can think of is to export
    to an appropriate neutral file type, open that in Excel and
    then save it as a worksheet.

    In this case try comma separated variable format (CSV) using
    the Export option from the File menu on either a table or a
    Select query which you have created to get the data you
    want.


    --
    Nick Coe (UK)
    http://www.alphacos.co.uk/ AccHelp is now Free
    http://www.mrcomputersltd.com/ Repairs Upgrades

    In news:18DF6E15-1029-49C5-A365-5183BA4607B7@microsoft.com,
    Bruce typed:
    > Trying to move about 85,000 rows of data to Excel (now
    > that
    > Excel has approx 1 million rows) and cannot copy and paste
    > due
    > to clipboard limitations; also get the same error message
    > regarding 65,000 record limit when attempting to export to
    > Excel.
     

Share This Page