Results 1 to 8 of 8

65,000 records

  1. #1
    kwooten is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    185

    65,000 records

    Is there any way to overwrite the 65,000 record limit?

  2. #2
    ssanfu is offline VIP
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    3,487
    Quote Originally Posted by kwooten View Post
    Is there any way to overwrite the 65,000 record limit?
    There is not a 65,000 record limit. Access can hold millions of records. I'm not sure why you think there is a limit. Access has a file size limit of 2 gigabytes.

    See:
    http://office.microsoft.com/en-us/ac...010030739.aspx
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  3. #3
    kwooten is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    185
    Maybe I should have been a bit clearer

    "You selected more records than can be copied onto the Clipboard at one time.

    Divide the records into two or more groups, and then copy and paste one group at a time. The maximum number of records you can paste at one time is approximately 65,000."

    I ran a DB and tried to export it to excel.

  4. #4
    ssanfu is offline VIP
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    3,487
    Quote Originally Posted by kwooten View Post
    Maybe I should have been a bit clearer

    "You selected more records than can be copied onto the Clipboard at one time.

    Divide the records into two or more groups, and then copy and paste one group at a time. The maximum number of records you can paste at one time is approximately 65,000."

    I ran a DB and tried to export it to excel.
    I haven't run into a clipboard limit, but Excel 2000-2003 worksheets do have a 65,536 row limit.
    Excel 2007/2010 row limits are 1,048,576 rows.
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  5. #5
    kwooten is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    185
    I knew that.. I am running Office 07. Ill figure it out

  6. #6
    TheBrigg is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    5
    I know this thread is a little old, but incase the issue is unsolved or someone stumbles upon it in the future like I did, here is some additional info.

    There is not a way to increase the limit. The only feasible method, aside from using something separate from Excel (highly advised), is to draw only 65000 records at a time and then copy/paste them. This is similar to what is called Pagination. After pulling records 1 to 65000, you would then pull records 65001 to 130000. It is a pain, but the only work-around that I'm familiar with.

  7. #7
    kwooten is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    185
    I figured out that if, when selecting to export to excel, you dont check any of the 3 boxes then the export will run all records.

  8. #8
    Cryptic is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2012
    Posts
    2
    More specifically, in the export wizard, leave the "Export data with formatting and layout" unchecked and it will export!

    MS KB article: http://support.microsoft.com/kb/924681

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access 2007 - Creating New Records Based on Existing Records
    By GeorgeAugustinePhillips in forum Forms
    Replies: 9
    Last Post: 10-05-2011, 04:58 PM
  2. Replies: 12
    Last Post: 08-30-2011, 02:36 PM
  3. Replies: 3
    Last Post: 07-10-2011, 04:37 AM
  4. Date function to query records and Sum records
    By sullynivek in forum Queries
    Replies: 0
    Last Post: 04-05-2011, 07:37 AM
  5. Replies: 7
    Last Post: 10-20-2010, 03:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums