Overwriting Duplicate SQL Data
Posted on 2006-07-10
I have an SQL statement that I am trying to run. How the whole thing works is I import a table into my existing database. The linked table is ARB1 and the one in the database is ARB. The following is the SQL statement I have in my code to import data from ARB1 into ARB.
I get the error duplicate data. How do I delete the duplicate data or delete the data first and then import the data?
DoCmd.RunSQL "INSERT INTO tblARB ( [Personnel ID Code] )SELECT tblStudent1.[Personnel ID Code], tblARB1.* FROM tblStudent1 LEFT JOIN tblARB1 ON tblStudent1.[Personnel ID Code] = tblARB1.[Personnel ID Code] WHERE (((tblStudent1.Instructor) Like [Who is the Instructor]));"