How to impor6t and combine two tables?

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

Guest

I have Access2000 and have set the e-mail field in a table not to except
duplicates so how do I import another table that has some duplicate
information.

What I am trying to do is update info from a remote location.
 
Short answer is you can't. But there are always ways to accomplish what you
can't do. First consideration is is it necessary to disallow duplicates for
this field? Not allowing duplicates is most useful when field is going to be
used in an index. If it is necessary that this field restrict duplicates,
would it be possible to prepend or append a unique identifer to the field to
make the entire value unique? For example, it could be similar in concept to
an autonumber. It would complicate your code and is not the prettiest of
solutions, but these are a couple of ideas off the top of my head.
 
Back
Top