junk values while importing excel to access

  • Thread starter Thread starter Prasath G via AccessMonster.com
  • Start date Start date
P

Prasath G via AccessMonster.com

Hai ,
I am trying to import excel in to msaccess , while importing i get
junk values in the fields where the data type is memo. Junk values in the
sense , a box like symbol . Is there anyway to rectify it .
 
Do the boxes appear where there are new lines in Excel? That could be
because Excel only requires a Line Feed character, while Access requires
both a Carriage Return and Line Feed.

Assuming you're using Access 2000 or newer, try using the Replace function
to change the LF (Chr(10)) to CR/LF (Chr(13) & Chr(10), or vbCrLf)
 
Back
Top