How can I import excel file same as excel data.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Is the field you are importing to a Text field?
Maybe you should try changing it to a Memo field instead.

jmonty
 
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
 
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.
 
Thank you for your help, John.


John Nurick said:
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
Click to expand...
Click to expand...
 
Back
Top