From: SMeric on
When I am trying to paste append some data from Excel to a table in Access,
some cells are added as blank cells. This happens only when the related
column's field type is "Text", and the pasted values contains both text and
number characters.

I did not face with this problem when I am using Access 2003.