Access Limitations and Importing Excel Files

G

Guest

Hello,
I was wondering if somebody could tell me what are the limitations of Access
in terms of how many records you can have in one database, I will be looking
at approx 250, 000 records?

2. Is it possible to import / merge 250 excel files into one access database
/ table, or would I need to have 250 seperate tables? The tables will all
have the same information fields.

Any help is gratefully appreciated!
 
V

Van T. Dinh

1. There is no official limit on the number of Records in Tables. There is
a size limit of 2 GB for the database file (1 GB for A97).

Type in Access Help Index "Specifications" for other limits.

2. Think of entity in your database. If all Records are of the same entity
(and it sounds like they are), they should be in the same Table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limitations of Access 2
Limitations on Split Databases 5
Creating new Access 2007 database and importing the old data 1
Import from Excel 2003 to Access 2003 4
Importing Text Files Into Access 1
Access limitations? 6
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Database size limitations 8

Top