Pasting email address into text field

  • Thread starter Thread starter REGREGL
  • Start date Start date
R

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?
 
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
 
Back
Top