Within a form, I'm importing an excel spreadsheet. After reviewing the data, I see that within some of the fields, ALT+Enter is within some of the fields. What is the easiest way to remove the ALT+Enter?
Thanks in advance!!
Competent Performer
Windows 7 64bit 
Access 2010 32bit
Within a form, I'm importing an excel spreadsheet. After reviewing the data, I see that within some of the fields, ALT+Enter is within some of the fields. What is the easiest way to remove the ALT+Enter?
Thanks in advance!!
VIP
Windows 7 64bit Access 2010 32bit
Do you mean the field has carriage return and line feed? Is there a character displayed?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Excel Import - Check if Spreadsheet Exists
Posting Permissions
Reply With Quote