Forum Discussion
Max number of table rows
Anyone know the maximum number of Table Rows allowed when importing Excel data to an Access Table
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?