--TripWire--
asked on
Get rid of duplicate records on Import
Hello,
I have a form in a MDB with a command button on it with the following code...
This code is meant to import the records from one Access (temporarily) table and append them to an existing table. The problem is, some records are showing up twice. Please help.
I have a form in a MDB with a command button on it with the following code...
CurrentDb.Execute "INSERT INTO tblInput ([FName],[LName]...etc) SELECT [FirstName], [LastName],...etc FROM tblTransfer WHERE [ThisField] IS NOT NULL, dbfailonerror
This code is meant to import the records from one Access (temporarily) table and append them to an existing table. The problem is, some records are showing up twice. Please help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<This may be not prctical for, say,100 000 records>
That is why I asked: "Are there lots of these?"
That is why I asked: "Are there lots of these?"
ASKER
I meant duplicate records. The entire row was copied. Thanks for the answers.
Use DISTINCT and primary keys appropriately.