Solved

Import Word Membership Report into Excel 2007

Posted on 2013-05-21
4
379 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

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

808 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