One way is to link to the spreadsheet as if it were a table.  Then use an
append query that can do the data transformation and append records to your
Access tables at the same time.

It may be necessary to use recordset processing to do this if the
transformation can't be done with SQL.  But, avoid using any make table or
temporary tables as they are big contributers to database bloat.