If the columns remain the same I would set up a table in Access with the formats that are compatible with the SQL server linked table.
I would then transfer the data from the import table to the formatted table using a query, it only take one line of code to run the query.