So I am able to successfully import my spreadsheet by adding the coding below as a module in my Access Database. However I expect the coding is far from bullet proof, and I need to be sure it will work going forward. As the coding came about by modifying code found on the internet I have little understanding as to if it is best suited for importing an Excel file to Access.
For instance, why am I using "Function" vs "Sub"?, Do I need to worry about error handling? Why is the Function "Public"? Etc.
Where I am asking for help is to "shore up" the coding to make sure it will work going forward. Thanks. - Tom
Option Compare Database
Public Function ImportEmployList()
DoCmd.TransferSpreadsheet acImport, 9, "Employee Table", "C:\Users\tom\Desktop\EDPR\Database Files\Employee List.xlsx", True