importing data

  • Thread starter Thread starter nydia
  • Start date Start date
N

nydia

I have a database that i enter client information. i
recently received 2 disk with new client information, it
is well over 800 new clients, so i don't want to have to
manually enter these clients, the disk have access
databases on them with the client info, how can i import
this information to my database. by the way, i did not
create the database that i work on.
 
You can import the table with the 800 clients into your database and then
create an append query to copy the 800 clients to your tables. After
completion just delete the imported table.

use: File | Get External Data | Import and then browse for the database.
Click on the database and locate the appropriate table. If the table has the
same name as your table it won't overwrite your table but add a value of 1
to the end.
 
Hi Nydia,

Working in "your" database, use File|Get External Data|Link to create a
table linked to the data in the first of the new databases.

You can then use queries to select the new data, change the field names
if necessary, and append it to your existing table(s).

This can be tricky, however - especially if it's possible that some of
the "new" clients are people who are already in your database and you
want to avoid creating duplicate records. Post back here if you need
more help.
 
Back
Top