Importing ZIP codes in different formats via query
 

I have multiple Excel spreadsheet of addresses that I have combined into a
master address list via queries of all of the parent lists. Some lists,
though, contain ZIP codes in both ZIP and ZIP+4 format. Whichever format is
the minority does not get imported into the master via the query. How can I
ensure that all data is imported?