Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Export Limitation (2000)

    I have a query in Access that I would like to export to Excel. The query contains 169,696 rows. When I export it to Excel, it only exports 65,536 rows. Is there a way to export all 169,696 rows? Thank you for any help you can provide.

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Export Limitation (2000)

    Hi,

    An excel worksheet is limited to 65536 rows of data. To export more rows to excel, you would need to run queries to break up the data to smaller subsets and export each set of data separately to excel.

    There is a feature in excel that will write data to multiple sheets should the data exceed 65536 rows but at the moment I can't remember how to do it.

    HTH
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •