Re: Avoiding duplicate information is database

Well, if it's a set of fields you want unique youcan make it a unique key in MySQL (assuming it's MySQL). I believe Access can also do this. Or, before inserting the data, do a select on the data first to determine whether or not it's in there. If the select statement returns zero rows, do the insert. On 10/26/00 12:55 PM this was written: > I've got a small database application that I am working on constructing to > put all of the dialup numbers that my company uses nation wide into an > easily updated DB. periodically I am sent new lists of numbers and I'd > like to be able to eliminate duplicates in the database I'm just not sure > how to go about it > or better still if anyone knows an application that already serves this > purpose or is readily adapted > please let me know...as much as I'm enjoying the learning I don't have time > to re-invent the wheel -- Thomas Deliduka IT Manager ------------------------- New Eve Media The Solution To Your Internet Angst http://www.neweve.com/