How to program to resolve the following problem. ..thx

[Artco News]

I came across a poster asking the same question but has not yet resolve the
problem. I have the same problem as well.

The problem is the multi-line cells(note: this is not the wrap around).

In a Word table, I have the following:

A B C D
1 L1 1stline $2.00 img1
2 2ndline
3 3rdline
4 L2 a line $5.00 img2
5 L3 llllllllll $1.00 img3
6

When I do cut-n-paste to Excel, I got
the same exact table as follow:

A B C D
1 L1 1stline $2.00 img1
2 2ndline
3 3rdline
4 L2 a line $5.00 img2
5 L3 llllllllll $1.00 img3
6

I am having trouble when I want to
import that table into an Access
Database.

I expect to get 3 records imported
in the database instead its 5 records
with with record 2 and record 3 has
empty first column.

Any pointer is greatly appreciated.

 

[Bob Kilmer]

In a Word table, I have the following:

A B C D
1 L1 1stline $2.00 img1
2 2ndline
3 3rdline
4 L2 a line $5.00 img2
5 L3 llllllllll $1.00 img3
6

When I do cut-n-paste to Excel, I got
the same exact table as follow:

A B C D
1 L1 1stline $2.00 img1
2 2ndline
3 3rdline
4 L2 a line $5.00 img2
5 L3 llllllllll $1.00 img3
6
....
I expect to get 3 records imported
in the database instead its 5 records
with with record 2 and record 3 has
empty first column.

You have 5 rows in Word.
You have 5 rows in Excel.
You expect 3 rows in Access?
Why?
I suggest that you rearrange the data into three rows in Excel then import
into Access.

 

[Useko Netsumi]

How would I rearrange all the multi-line cell into a single line cell
PROGRAMMATICALLY.

I know in Excel you can use <CTRL-ENTER> to get a soft-newline in a cell
instead of a hard-newline with CR/LF character.

Anyone? Thanks