Solved

Import Word Membership Report into Excel 2007

Posted on 2013-05-21
4
377 Views
Last Modified: 2013-05-23
Import Word Membership Report into Excel 2007

Using the following 'Instructions', step 4 returns no data in Word file conversion window. Step 3 ['Click the "Advanced" tab...'] seems the cause of the problem. Attached 'Sample Membership Record.jpg' is a sample record (row) from MS Word 2007 table. If Step 3 is not done, output is available, but not delimited correctly.

As am trying to create a delimited [; - semicolon is delimiter] Excel 2007 input file, how do I proceed?


Instructions

1 Open a Word document you want to import.

2 Click the "Microsoft Office Button." Click "Word Options."

3 Click the "Advanced" tab. Under "Preserve Fidelity when Sharing this Document, click "Save Data as Delimited Text File." This feature will allow Excel to read the file you are going to import. Click "OK."

4 Click the "Microsoft Office Button." Choose "Save as." Under "Save as Type." Select "Plain Text." This will save the file as a .txt file. A file conversion window will appear. Click "OK."

5 Open Microsoft Excel.

6 Click the "Data" tab. In the "Get External Data," click "From Text."

7 Select the file you just saved in step 4. Click "Open." The Text Import Wizard will appear.

8 Select "Delimited" under "Original Data Type." Click "Next."

9 Select the delimiter you want to use. For instance, check "Comma" instead of "Tab" to see how it affects the conversion. Click "Next." Click "Finish."

10 Click in the first cell (A1) in Excel. Click "OK" to import the data.


URL: http://www.ehow.com/how_6455437_import-word-document-excel_.html#ixzz2Tw02jOhh
Sample-Membership-Record.jpg
0
Comment
Question by:MARSPATH
  • 2
  • 2
4 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 39185641
The "Save Data as Delimited Text File" is actually labelled "Save form data as delimited text file". The missing word "form" is important because the process only saves the data that is in Form Fields. You haven't mentioned that your text is in form fields so I suppose that it isn't.

It does look as if the text might be in a table, but without seeing the document or a redacted sample part, we can't be sure.  It is possible to select a table in Word and to paste it into Excel.
0
 

Author Comment

by:MARSPATH
ID: 39185735
How do I know if data is in table? Attempts to merge rows fails as there is no "Layout" tab or "Table Tools" in the Ribbon. I have tried several ways to select table, Ctrl-A, click upper left table corner, Select in Editing Menu - No Go
0
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 39186176
If the Layout or Table tools tabs don't appear when the cursor is in the structure, then there may not be. However it looks like a table with double borders - there are even like cell delimiters: ¤ at the end of the text in each 'cell'.
0
 

Author Closing Comment

by:MARSPATH
ID: 39190990
Solved by exporting to delimited text file.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question