junk values while importing excel to access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Prasath G - 26 Mar 2005 11:31 GMT

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 .

Reply to this Message

Douglas J. Steele - 26 Mar 2005 12:41 GMT

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)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> 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 .

Reply to this Message