jm14:
The auto execute is a excellent idea. (I've also been searching the Access and Excel post, and while I've found some great info, the auto execute appears to be cleanest solution.)
Norie,
Also a good idea, however data is forwarded to us in Excel format. I am setting the file up so that others who would like to clean the data (who tend to be a timid when it comes to Access) will not need to leave the comforts of Excel. The end goal is to build an Access table that users can query from Excel.
Thank you both for your input.