automatic add excel sheet data to access database

if your question is how can I add an excel sheet data to an access database automatically, one way to accomplish that is to use the import function in access for your sheet, then the last step of the import process is do you want to save that template. Click yes and you can just run it again anytime by simply selecting run saved import in your access database. Is that what you want?

An alternative to Sambo Kid is to link your spreadsheet so long as your spreadsheet is normalized. In this manner, your spreadsheet will look and act like a table in your database.