Pasting email address into text field

[REGREGL]

Hello all,

I am attempting to copy/paste several rows of data from an excel spreadsheet
into an Access form. I receive an error: "The value you have entered into
this field is invalid" when the data contains an email address. The email
address field is set for text with a field length of 255 characters in the
DB. I can copy the individual email address into the field without any
problems. the problem occurs only when I am copying the whole row or rows of
data from the excel spreadsheet into the Access DB.

Any ideas about getting around this problem?

 

[Jeanette Cunningham]

Hi,
this is exactly what happens with Access when you try to do a manual copy
and paste.
Could you link to the spreadsheet and use a query to get the values from
excel and add them to the table your form is based on?

Jeanette Cunningham