Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Sep 2003
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Export to Excel > 65000 rows (2000)

    How do you get Excel to put data in multple sheets when the data exceeds 65000 rows? I have a query in Access that I am trying to export to Excel but the data exceeds 65000 rows. Is there any way to get Excel to accept more than 65000 rows? Does this have to be done in Access?

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Export to Excel > 65000 rows (2000)

    Hi.
    Could I ask why you want to export to excel first?
    You cannot analyse a list in excel that is split over two sheets anyways. It sees it as two seperate lists. This complicates matters terribly!
    If you can filter the data to less that 65536 records then that is great, else keep it in access and do the data analysis there.
    Regards,
    Rudi

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Export to Excel > 65000 rows (2000)

    Check out <post#=396487>post 396487</post#>

    Steve

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export to Excel > 65000 rows (2000)

    The data does not need to be analyzed. The people who need the data, want it in Excel. They are not familiar with Access.

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Export to Excel > 65000 rows (2000)

    In that case...have you looked at the post that Steve has forwarded to you. He has a macro that will allow you to deposit more than 65536 rows into excel. This may prove very handy 4 you!
    Regards,
    Rudi

Posting Permissions

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