Back in January, I promised to post a macro that imports data from Excel into Access programmatically.
Formatting Zip+4 Codes
If you have a column of zip+4, this macro will remove the suffix. Simply highlight the cells in question. It will skip any zip codes that don't have the suffix. It uses the Left$ string function which is more efficient than the standard Left() and always returns the first 5 characters in the cell.
Follow Me