Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    new orleans, louisiana
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    import a word table

    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!

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: import a word table

    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.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    new orleans, louisiana
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: import a word table

    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.

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: import a word table

    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 (
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •