Access Merging Database

[jayswt99]

Yes, I have two databases created using Access and I am trying to merge them.


I will call the first file clean and second dirty. The clean file is exactly how I want it to look, but the dirty file has items I do not want to merge, the only information I want merged and changed are two particular columns. Is there a way to merge the files and exclude certain data or to have it delete certain data in the merge?

 

[le13enforce]

Why don't use open dirty, remove everything except for the two columns you want to merge, save, then merge with clean?