MICROSOFT ACCESS 97: ADVANCED

Access will automatically add Fields with the same name in the Destination Table to the Append to row. Change the Append to Fields if appropriate. In the example below, records from tbl_patient_new will be appended to tbl_patient with data from the PatientName Field going to the corresponding Field of the same name and data from the Doctor Field going to the StaffNumber Field. ................
................