The simple answer to that is a resounding yes, and we will discuss how to get the job done in the best and easiest way. Remember that we are using Access and Excel from Microsoft Office 365, so if you ...
I have a pre-existing table in Access called "CAMPER". I'm importing an Excel spreadsheet to that table which may or may not contain records already in the table. Here's the pertinent import code.