Max number of table rows

Copper Contributor
Anyone know the maximum number of Table Rows allowed when importing Excel data to an Access Table
1 Reply
There is no limit, at least theoretically on the Access side. I have seen Access tables with a couple million rows. The limitation is the overall size of the accdb, which is 2GB. Practically speaking, though, an accdb over 1 GB is probably not desirable. I believe the maximum number of rows in an Excel worksheet is around 1 million, is it not?