Microsoft KB Archive/106303

{|
 * width="100%"|

INF: How to Use an Analyzer Table in a Word for Windows Table
'Article ID: Q106303

Creation Date: 04-NOV-1993

Revision Date: 19-SEP-1996' The information in this article applies to:


 * Microsoft Access versions 1.0 and 1.1

SUMMARY

This article describes how to paste Microsoft Access Database Analyzer output into a Microsoft Word for Windows text table so it can be more easily edited into "data dictionary" format.

MORE INFORMATION

If you have not already installed the Microsoft Access Database Analyzer, do so by following the directions in the following text file:

 For Microsoft Access version 1.0, follow the directions in the PSSKB.TXT file. -or- For Microsoft Access version 1.1, follow the directions in the ANALYZER.TXT file.

Once you have installed the Database Analyzer, you can use the following example to paste analyzer output into Word for Windows:  Run the Database Analyzer. A table will be created in your database. Open the table created by the Database Analyzer. From the Edit menu, choose Select All Records, and then choose Copy from the Edit menu. Open or switch to the Word for Windows document into which you want to paste the table. From the Edit menu, choose Paste.</li> Select the information you just pasted into the document, and then choose Convert Text To Table from the Table menu.</li> Place the insertion point in the Table Name column, and then choose Select Column from the Table menu. Delete the column by choosing Delete Columns from the Table menu.</li>  Change the table headings as follows: Old heading      New heading -     Name              Field Name Type             Data Type Length           Length IndexName        Comments </li> Size the column widths as needed.</li></ol>

You can use the comments column for descriptions of the fields in the table.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED 'AS IS' WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

Additional reference words: 1.00 1.10

KBCategory: kbusage

KBSubcategory: GnlOthr