I prefer to link to the Excel file to maintain the integrity of the Excel data. If the Excel is the main source of the data (Call it Workbook A) I would create a new Excel file, Power Query the data and fix the formats etc (Call that Workbook B) then link Workbook B to Access.
That way Workbook...