Paste error

[Matt]

I have a table that I am trying to paste data into from
another table, and when I paste it I receive the error
message "The field is too small to accept the amount of
data you attempted to add. Try inserting or pasting less
data". Some of the rows did paste, while the others went
to the Paste Errors table. The field that is causing the
error is a Text field and is set to a Field Size of 40,
but for some reason will give me the above error message
for any that has a Text Size more than 3. Any
suggestions? Thanks in advance for your help.
- Matt

 

[John Vinson]

I have a table that I am trying to paste data into from
another table, and when I paste it I receive the error
message "The field is too small to accept the amount of
data you attempted to add. Try inserting or pasting less
data". Some of the rows did paste, while the others went
to the Paste Errors table. The field that is causing the
error is a Text field and is set to a Field Size of 40,
but for some reason will give me the above error message
for any that has a Text Size more than 3. Any
suggestions? Thanks in advance for your help.
- Matt

Well... don't use Copy and Paste for starters. If you must move data
from one table to another (rare, since storing data redundantly is
never a good idea) use an Append Query to do so.