import af Excel

You can try importing the file using the import wizard. In the wizard there is an advanced button which gives you further options. You can also choose each fields data type if I remember correctly. You could try alterin the field you are having problems with to a MEMO.

You could alsoo try improting as normal and then update the field with something like this

Replace([This is the field you want to update], chr(9), chr(13)+chr(10))

you could do this in an update query

terry:

jeg har forsøgt at lave det til MEMO...det hjalp ikke.

din updaterings streng virker heller ikke, forstået således at der ikke foretages en updatering. Det er jo nok fordi der ikke er tale om en tab, men den ligner bare en tab i filen... (den lille firkant)

du kan jo selv prøve det ved i excel at skrive flg.:

bilen er rød (ALT+ENTER)
og har 4 døre (ALT+ENTER)
som alle kan åbnes


Prøv at importere denn i access, så vil du se at der kommer små "tab-firkanter" hvor der skulle have været et linieskift

OK, so we just need to find the value of Alt+Enter and then use the update. it may just be a line feed (10)

Back soon

this helped ;-)

Replace([Copy of ny]![Familien tekst];Chr(10);Chr(13)+Chr(10))

THX...

its just a line feed (chr(10))

UPDATE Sheet1 SET Sheet1.Field1 = Replace([field1],Chr(10),Chr(13)+Chr(10));

:o)

thanks