How to Open Word for Windows Table in Microsoft Excel Q+E

ID: Q89789

The information in this article applies to:

Microsoft Word for Windows versions 1.0, 1.1, 1.1a, 2.0, 2.0a, 2.0a-CD, 2.0b, 2.0c, 6.0, 6.0a, 6.0c
Microsoft Q+E for Microsoft Excel for Windows, versions 3.0 and 4.0

SUMMARY

To format a Word for Windows table so that you can use it in Q+E for Microsoft Excel:

1. In Word for Windows, open the document that contains the table you

   want to use in Q+E. Select the entire table. From the Table menu,
   choose Convert Table To Text (in versions 1.0, 1.1 and 1.1a of Word
   for Windows, choose Text To Table from the Insert menu). Select the
   Commas option and choose the OK button.

   Note: If your table contains commas as punctuation, select the Tabs
   option instead of the Commas option in the Convert Table To Text
   dialog box.

2. Save the file in the Text Only file format.

3. Start Q+E. From the File menu, choose Open.

4. In the Source box, select Textfile and choose the Options button.

5. In the Open Options dialog box, select the IBM PC and Character

   Delimited Values options. In the Delimiter Character box, type ","
   (without the quotation marks).

   Note: If you selected tabs instead of commas in step 1 above, type
   "tab" (without the quotation marks) in the Delimiter Character box
   instead.

   Select the First Line Contains Field Names option if your table
   contains field names in the first row. Choose the OK button.

7. Select your text file from the list of files and choose the OK

   button. The text records from the Word for Windows table should
   appear as separate records in a Q+E Query.

8. If you want to save the text file in Q+E database file format,

   choose Save As from the File menu. Type a filename (Q+E uses the
   .DBF extension by default). Select dBaseFile in the Destination box
   and choose the OK button.

Reference(s):

"Q+E for Microsoft Excel User's Guide," version 4.0, pages 137-139, 141

"Microsoft Word for Windows User's Guide," version 2.0, pages 318, 675-679

KBCategory: kbusage kbhowto KBSubcategory: kbtable Additional query words: 1.0 1.10 1.10a 2.0 2.0a 2.0a-CD 2.0b word6 winword 6.0 winword2

Keywords          : kbtable 
Version           : 1.x 2.x 6.0 6.0a 6.0c
Platform          : WINDOWS

Last Reviewed: February 6, 1998