If the fields are static across all the workbooks, you can dump data into Access using the following (super easy to use) :
[vba]
Sub DAOFromExcelToAccess()
Sheet5.Activate ' make sure proper sheet is selected to
load data
' exports data from the active worksheet to a table in an
'Access database
Dim db As Database, rs As Recordset, r As Long 'declare
'variables (DB & table)
Set db = OpenDatabase("I:\filepath\databasename.mdb") '2003 DB
' open the database
Set rs = db.OpenRecordset("TYPE_TABLE_NAME_HERE", dbOpenTable)
' get all records in a table
r = 1 ' the start row in the worksheet
Do While Len(Range("A" & r).Formula) > 0
' repeat until first empty cell in column A
With rs
.AddNew ' create a new record
.Fields("DATE") = Range("B" & r).Value
.Fields("EMPLOYEEID") = Range("C" & r).Value
.Fields("TIME") = Range("D" & r).Value
.Fields("SALE") = Range("E" & r).Value



' add more fields if necessary...

.Update ' stores the new record
End With
r = r + 1 ' next row
Loop
rs.Close
Set rs = Nothing
db.Close
Set db = Nothing

'Call CountData 'count records loaded
ScreenUpdating = True

MsgBox ("successful!")

End Sub
[/vba]
Make sure you add the reference in VBA to Microsoft DAO 3.6 (excel 2003, or the other one if your in older version. You can even take it one step futher and run an update query in Access to dump it into Oracle/SQL Server if you don't like Access.

You can also use similar code to run queries from within Access too (i.e deletes).