What is the max number of record that can be imported into access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the max number of record that can be imported into access? I'm
appending a table in access using monarch and I'm getting an error. I don't
know if its because I've max out the number of records that access can
handle. Thanks.
 
in access help type specifications
the only thing i saw was that a recordset could not exceed
1 gig.
 
There isn't one. There's a maximum database size of 2 GB in Access 2000 or
later, or 1 GB in Access 97, but there is no maximum number of records.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
There's no limit on the number of records as such. There's a limit of
2GB on the size of an mdb file - which includes everything else in the
database including indexes, which can be a significant factor if you are
appending hundreds of megabytes. There's also a limit of about 2000
characters per record (excluding memo and OLE fields).

Compact your database before appending the data. If you're appending
hundreds of megabytes data, create the table manually first, with no
indexes; append the data; and finally create the indexes.
 
Hi All,

I'm most probably preaching to the converted here, but you may want to try the following if the size is geting an issue,

Create a datawarehouse, either in the form of another database or stored files, simply write a query to export the date to another when the data gets more than 6 months old, or seperate the information by customer. Once they export use a delete query to remove them from your current database. Alternatively, I like to export my data as XML files with a date-name reference using the exportXML VBA command.

These files really help as you can quite easily import them into other databases for reporting, reevaluating etc. It also means the occasional corrupt database doesn't lose all your information.

Hope this is of some help.

Regards

Greg
 
Thanks for the info. At the point of import, the datbase size was at 1.6GB. I
must be exceeding it during the import process. Thanks to all.
 
Back
Top