PDA

View Full Version : vblf's peculiarities



mikeo1313
08-02-2010, 12:14 AM
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
08-02-2010, 12:27 AM
Instead of vblf why not use ascii code Chr(10) for your carriage return?

mikeo1313
08-02-2010, 12:42 AM
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
08-02-2010, 02:08 AM
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.