Appending Linked Tables with Different Field Names

[D_Houle]

I’m hoping someone can help me. I have 2 linked tables that contain the same
information (except for the headings). For example one column says “Last
Name†and the column containing last names on the other table says “Borrower
Last Nameâ€. I would like to be able to append the 2 tables into 1 table. I
will be saving over the source files regularly and do not want to have to
change the heading each time I save them. I am hoping someone can help me
out.

Thanks,

-D

 

[John W. Vinson]

I’m hoping someone can help me. I have 2 linked tables that contain the same
information (except for the headings). For example one column says “Last
Name” and the column containing last names on the other table says “Borrower
Last Name”. I would like to be able to append the 2 tables into 1 table. I
will be saving over the source files regularly and do not want to have to
change the heading each time I save them. I am hoping someone can help me
out.

Thanks,

-D

An Append query can very easily read from one fieldname and write into another
one. Create a Query based on your source table; change it to an Append query;
specify the target table, and then match up each field name with the
Destination fieldname.