if you want to manually cut and paste this stuff, you have to make sure that the entire cell is selected in access (no cursor showing in the cell) before being able to paste. and i'm not even sure you can paste in the middle of a table in access, but you certainly can do it from the top of the table by selecting the column.
writing code for this will be difficult because it is long and complicated. unless you get it from somewhere else, I would suggest using the intellisense dropdown in excel to learn what library objects you are going to need first.