Importing a file

S

salintag

I am importing names and addresses into a database from Excel files. Each of
these has an account number. After importing, the database rejects those
that are already in the system with the same account number. That's what I
want. I only wan to add the new ones. However, I would like to capture a
list of the new ones accepted. Is there any way to do this?
Sal
 
K

Klatuu

Either link to the spreadsheet or import it into an itermediate table.
Create a query that will show you rows that are in the spreadsheet but not in
the current table. Then append those to your current data.
 
S

salintag

Thanks for the prompt reply. The technique you suggested should work fine,
although my hope was that there was some simpler way in the import that would
just automatically give me the differences, like the error table created for
some entries.
 
Top