(Msg. 1) Posted: Tue Sep 30, 2003 9:21 pm
Post subject: How to import Multi-line cells in a Word table into Excel Archived from groups: microsoft>public>excel>datamap (more info?)
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.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum