Microsoft KB Archive/89789

{|
 * width="100%"|

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

 * }

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.
 * 1) Save the file in the Text Only file format.
 * 2) Start Q+E. From the File menu, choose Open.
 * 3) In the Source box, select Textfile and choose the Options button.
 * 4) In the Open Options dialog box, select the IBM PC and Character Delimited Values options. In the Delimiter Character box, type ,.

Note: If you selected tabs instead of commas in step 1 above, type tab 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.
 * 1) 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.
 * 2) 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.