WD95: How to Export a Word Table to a Database or Spreadsheet Application

• Microsoft Word for Windows 95, versions 7.0, 7.0a

SUMMARY

Microsoft Word does not allow you to directly save your Word document as a Microsoft Excel, Lotus 1-2-3, dBase, or other database or spreadsheet file. This article provides the steps for converting your Word table into a file format that can be easily imported into a database or spreadsheet application.

MORE INFORMATION

To export information from a Word table to your particular spreadsheet or database, use one of the following methods:

NOTE: These procedures assume that your Word document only contains a table that you want to import into either a database or a spreadsheet application. If your Word document contains other text outside the Word table, you may get unwanted results.

Method 1: Save Using the Text with Layout Converter

1. Open your Word document that contains the table you want to import into a database or spreadsheet application.



2. On the File menu, click Save As.



3. In the Save As dialog box, change the Save as type box to Text with Layout (*.ans) and click Save.
   
   NOTE: You may also want to rename your file to a new file name before you click Save. Your new file will have the *.ans file extension.

Method 2: Convert Your Word Table to Text

1. Determine which field delimiting character your spreadsheet or database software recognizes when importing ASCII or ANSI text files.



2. In Word, place the insertion point inside a cell of the table. On the Table menu, click Select Table.



3. On the Table menu, click Convert Table to Text.



4. In the Convert Table to Text dialog box, click either Tabs or Commas, based on the delimiter your spreadsheet or database application accepts, and then click OK.



5. On the File menu, click Save As. Change the Save as type box to Text Only (*.txt) and click Save.
   
   NOTE: You may also want to rename your file to a new file name before you click Save. Your new file will have the *.txt file extension.



6. If Word prompts you with the following message when you close the file, click No:




This document contains formatting that cannot be saved in text format. Do you want to save changes to <filename.txt>?

Additional query words:

Keywords : kbdta word7 word95
Version : WINDOWS:7.0,7.0a
Platform : WINDOWS
Issue type : kbhowto