Mailing List Table

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

Guest

Working on a mailing list table with 10K plus records without any primary keys. Most of the time, have to import from Excel spreadsheets more reocrds. Is there anyway I can control duplication of same names etc. ??? Thanks
 
Working on a mailing list table with 10K plus records without any
primary keys.
Click to expand...

If it doesn't have a primary key, it's not a table. It's an unordered
junkyard.
Most of the time, have to import from Excel
spreadsheets more reocrds. Is there anyway I can control duplication
of same names etc.
Click to expand...

Yes: but you have to be very clear what you mean about duplication. If you
are looking at values like "AK098002" then it's straightforward -- just
query the table before adding the value

If DCount("*", "MyTable", "MyValue = """ & strNextValue & """") _
= 0 Then
rs.AddNew
rs!FirstValue = strFirstValue
rs!NextValue = strNextValue
' etc
rs.Update

End If

and so on. On the other hand, if you are looking at names, detecting "John
Smith", "Smith JA", "Smith, JA", "John A. Smith" and so on will take much
more sensitive programming.

Hope that helps


Tim F
 
Back
Top