Horizontally merge (combine, match, union) two Access tables into one by a common column (field) of data. The two tables can be located in the same Access file or two different Access files. The two tables are not changed, a new table is created with the results. No complicated options or SQL knowledge required.