Microsoft KB Archive/106303

From BetaArchive Wiki

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:

  1. Run the Database Analyzer. A table will be created in your database.
  2. Open the table created by the Database Analyzer.
  3. From the Edit menu, choose Select All Records, and then choose Copy from the Edit menu.
  4. Open or switch to the Word for Windows document into which you want to paste the table.
  5. From the Edit menu, choose Paste.
  6. Select the information you just pasted into the document, and then choose Convert Text To Table from the Table menu.
  7. 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.
  8. Change the table headings as follows:

          Old heading       New heading
          -----------------------------
          Name              Field Name
          Type              Data Type
          Length            Length
          IndexName         Comments
  9. Size the column widths as needed.

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