Adding lines to Access 2002 table

E

EricT

Is it possible to add 32,000 lines to an Access 2002 table that already
contains 2 approximately 200,000 lines already? I am attempting to copy and
paste the lines from Excel 2002 and it stops after about 24,000 lines. Any
ideas?
 
G

Guest

it is to my understanding that there is no limit to how
many records can exist in an access table in theory. there
are some real world restrictions such as hard drive size,
memeory ect.
but copying and pasting 32k records is a lot.
Have to considered linking to the excel file and writing
an append query that would append the excel data to the
access table? or use the import function to append it to
the table?
 
B

Brendan Reynolds

Try linking the Excel file as a table, and using an append query to append
the rows to the Access table.

--
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.
 
Top