Was also looking for a solution to this problem.... proposed solution doesn't work since you can't change it back to autonumber after.
The workaround that I found works best is to import the data you are wanting to copy from, then use an append query to paste the data. Access will also...