import a word table

Topic

New Reply

i’m very new. i have a table in word that came from a wordperfect design. i would like to have it in either excel or access to be able to search better. in importing to excel, it lost the original rows configuration and looks like each row is split into one or two rows in excel. any ideas on either importing, merging existing data? there are about 1000 different tables in word holding the various fields, and i would need to add two more fields to be able to utilize it easier in a database than in the separate tables. thanks for any help!

Reply | Quote

Replies

Can you convert to Word format and then import? Simple Word tables drop right in to Excel.

Otherwise you may need to convert it to text and use the Data, Text-to-Columns tool.

Reply | Quote

the word table is the one that came into excel splitting the ‘rows’ or ‘cells’. some of the word table cells are very fat with wrapped text, and they came into excel split into 2 or 3 cells.

Reply | Quote

I note that you have 1,000 tables to convert, so you may want to look for better solutions than I can offer.

However, here’s a couple of tricks; a Word cell with a paragraph break (

Reply | Quote