Importing Excel Files and losing Line Breaks

[enbw]

I have created a spreadsheet in which some of the cells contain line breaks.

When I import this into Access 2000 the line breaks are formatted as characters and thus losing the format when using the field in a form.

How can I ensure the formatting is correct?

Many thanks

 

[WildHare]

Are you SURE the cells actually contain line breaks, eg ASCII Chr$(10) and Chr$(13), or is the FORMAT of the cell simply allowing word wrap?

It sounds suspiciously like you might be pulling in TWO different pieces of information, rather than one long text string.

Can you give us an example?



Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[enbw]

Hi,

Thanks for the reply. I am migrating out of a PICK database into a flat file and then up into excel. Within the flat file the pick system produces two characters which denote a line break. In excel there is a small macro which replaces these characteres with &chr(10)&chr(13) which generates the line break, if word wrap is off this is denoted by a square character.

In excel if you create a cell with three lines in it using alt+enter this switches the word wrap on. I am not quite sure of the way forward.

Basically, I need to be able to take the flat file and in a form to show the contents with the original line breaks.

Thanks