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:
- 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.
- Save the file in the Text Only file format.
- Start Q+E. From the File menu, choose Open.
- In the Source box, select Textfile and choose the Options button.
- 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.
- 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.
- 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
|