MAKING BIG LIST

[Guest]

I need to combine several large files into one database. Each file contains
the same field types, i.e., name1 name2 your#. Duplicate values may exist in
each file and need to be preserved. Files can contain as many as 90,000
records.
How do I build the large list?
Thanks,

John

 

[Joseph Meehan]

I need to combine several large files into one database. Each file
contains the same field types, i.e., name1 name2 your#. Duplicate
values may exist in each file and need to be preserved. Files can
contain as many as 90,000 records.
How do I build the large list?
Thanks,

John

First that is not really a big list by Access standards.

Second depends. What do you want to do when there is a duplicate?

After resolving the duplicate issue it sounds like an simple append
query.

 

[Guest]

You don't say what format your files are in but assuming you can import into
an Access table you should be able to use Append queries to get them all into
1 table. You can have duplicates as long as you don't set a primary key on
the field that contains duplice records.
Sheila