How can I import excel file same as excel data.

[Guest]

Carriage return (Alt+del) in excel data in one cell is imported to small
aquare box into the place of carriage return. Some one have magic idea to
import same as excel?

Excal source data
I hope this work
A) It should work this way

After import to Access
I hope this work â–¡ A) It should work this way

 

[Guest]

Is the field you are importing to a Text field?
Maybe you should try changing it to a Memo field instead.

jmonty

 

[Guest]

Carriage return (Alt+Return) in excel data in one cell is imported to small
square box into the place of carriage return. Some one have magic idea to
import same as excel?

Excal source data
I hope this work
A) It should work this way

After import to Access
I hope this work â–¡ A) It should work this way

 

[Guest]

Thank you for your message, but does not work for my case.

 

[John Nurick]

Hi Ken,

Excel uses the LF (linefeed) character - Chr(10) - to indicate a newline
within a cell. Access requires the standard Windows newline, the two
characters CR and LF - Chr(13) & Chr(10).

Usually the simplest thing to do is to import the data as is, and then
use an update query to make the changes. If the field name is XXX,
update it to
Replace([XXX], Chr(10), Chr(13) & Chr(10))

That will work in Access 2002 and later; post back here if you are using
an earlier version.

 

[Guest]

Thank you for your help, John.

Hi Ken,

Excel uses the LF (linefeed) character - Chr(10) - to indicate a newline
within a cell. Access requires the standard Windows newline, the two
characters CR and LF - Chr(13) & Chr(10).

Usually the simplest thing to do is to import the data as is, and then
use an update query to make the changes. If the field name is XXX,
update it to
Replace([XXX], Chr(10), Chr(13) & Chr(10))

That will work in Access 2002 and later; post back here if you are using
an earlier version.

Carriage return (Alt+del) in excel data in one cell is imported to small
aquare box into the place of carriage return. Some one have magic idea to
import same as excel?

Excal source data
I hope this work
A) It should work this way

After import to Access
I hope this work ? A) It should work this way