Copy and paste from Excel to access.

Is it possible to copy and paste a range from Excel 2003 to Access 2003
where the format of the excel *** matches the format of the datagrid?
Access responds with "the text is to long to be edited".

If not, is there any other way to copy in ranges of data to update or append
to an existing access table? I might want to update or I may want to append.
I though if I selected the correct record and pasted it would flow down and
change the values ot would have pasted over but it doesnt work.


.