View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Artco News Artco News is offline
external usenet poster
 
Posts: 1
Default How to program to resolve the following problem. ..thx

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.