Thread: Carriage Return Line Feed

I import data from Excel 2010 to Access 2010 with Excel line feeds in some of the cells. When access opens the table it ignores the LF code from excel (chr(10)) or is it vblf ???

I tried Find/Replace for chr(10) and chr(13) and vbcrlf and vblf to no avail.

Access uses ctrl+enter and Excel used alt+enter (what is that all about? don't the developers talk to each other?)

How can I get Access to recognise the LF and not look for CRLF.

Excel works if the CRLF is imported from Access.

This should be function of the Access code because access does not use LF for anything.

I really do not want to write VBA code if I do not have to.

Opened an forum thread on MS Forums but only suggestion was to write VBA code. see http://www.accessforums.net/import-e...eed-11304.html