If i understood correctly. You have some data in MS Excel which you want to move to MS Access and you are using Paste Apppend option. The issue you are facing is that link are getting truncated in MS Access.
Please check the type and size of field. You can change the field type of link to memo.
<a href=”http://findsarfaraz.blogspot.com”>MS Excel help</a>