vblf's peculiarities

[mikeo1313]

I got external excel data into an access database.

my problem is that it seems like the vbLF's are gone. I have to explicitly copy data from one cell of excel to access for the linefeed to show, 1 by 1.

Do vblf's & memo fields not mix?

Do vbcrlf's work out better???

HOW CAN I convert all my VBlf's in a column to VBcrlf's???

[Simon Lloyd]

Instead of vblf why not use ascii code Chr(10) for your carriage return?

[mikeo1313]

I'm open to anything that will work.

Do you have an access or excel vba I can use to replace vblf's with what your suggesting?

[Simon Lloyd]

where are the vblf's? in code or in the worksheet?, either way why do you need code to replace them? simply use Excel?Access Find & Replace from the Edit section of the menubar.