How does one import and not get duplicate information

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

Guest

I am importing a spread sheet from an associate. he update information every
4 hours. I will import his spread sheet in the morning and again in the
evening. When importing in the evening I get all the data he sent in the
morning again as he does not need to delete it. Is their a way to have my
data base compare the information and import on that data which is new?
 
Nick,

If there is one field or combination of fields (columns in the Excel
spreadsheet) that is unique for each record (spreadsheet row), then the
easiest thing to do is make that field or combination of fields the
Primary Key in the target table, which will automatically reject duplicates.

If there is no way to uniquely identify rows based on the data alone,
then I'm afraid you will need to ask the associate to timestamp the rows
- unless, of course, someone comes up with a better idea!

HTH,
Nikos
 
Back
Top