troubleshooting Question

Append table without duplicate value

Avatar of rowfei
rowfei asked on
Microsoft AccessVisual Basic Classic
2 Comments1 Solution354 ViewsLast Modified:
I am using the following codes to append table 1 to table 2.

CurrentDB.Execute "INSERT INTO tbl_Data2 (field1, field 2, field 3) SELECT [Valume1], [Valume 2], [Valume 3] FROM tbl_Data1", dbFailOnError

But it creates duplicate data in table 2. How can I set filter to append only record that have field 1 and filed 2 are not into table 2?

Thanks,
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros