Share via

Access limitations

Anonymous
2015-09-24T09:44:28+00:00

Is anyone else frustrated by the fact that Access (even in 2016) will not let you copy more than 65,534 records?  This dates from Office 2003, when Excel only had 65,000 rows. 

However, in 2007, Excel expanded to 1Mill rows.  This means I can copy and paste hundreds of thousands of rows from Excel to an Access table, but I'm restricted going the other way.

This artifact has now existed through 4 versions of Access.

I'm also frustrated that the 2GB limit hasn't expanded in this era of "Big Data". 

I realize that there are a few workarounds for the 2GB limit, and you can use EXPORT to Excel rather than Cut/Paste.  But it is totally out of sync with EXCEL capabilities.  You can copy and paste 200,000 records from EXCEL to Access, but not the reverse.

MarkBJohnson_52

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,830 Reputation points Volunteer Moderator
    2015-09-24T11:50:39+00:00

    Personally, I'm not bothered at all. I've never encountered a need to copy and paste large amounts of data. I either export the data or I'm using a filtered recordset. 

    I would have liked to see the 2G limit expanded, but I think that was left to push people to SQL Server when data needs get that large.

    Was this answer helpful?

    0 comments