VBA Code Within Excel to Update Access Database

[RankSinatra]

Hello, I don't know what I'm doing. Great start.

I am looking to update an access database from an excel spreadsheet. I want to link the fields by the first row in the excel spreadsheet (i.e. "EmployeeName", "Location", etc.). The spreadsheet itself has a different filename as we resave the master copy for each day, so we have "Closing Paperwork 1/26/18" for today and so on for the following days, so the code needs to be on Excel's side I assume. Is there a way to have the inputs in the excel table link to access as new fields? I want to prevent overwriting, if that's a thing that happens.

One last request, I only want complete records to copy over, or only the rows that have all cells in the row that have data. It's a cash handling variance tracker, so if they have no variance I don't want their name/location in the Over/Short database. I hope that makes sense.

[CK76]

Upload sample workbook showing what record you want to push and what record not to.

There are multiple ways of doing this. DAO, ADO, adding reference to Access application in the project and using Import etc, etc.

Probably the fastest method is to use sql statement to [i]nsert into table.

One such example below.
https://stackoverflow.com/questions/...s-access-table

However, generally speaking it's safer to read from closed workbook and from Access side.