Solved

Import Word Membership Report into Excel 2007

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

910 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now