Copy/Paste from Excel
View Single Post
Since, your excel file is also linked to the Access database you may use and
, using Excel Table as
and the Access Table as
. This will transfer the data correctly to the Access Table.