Microsoft KB Archive/44020

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 16:56, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Microsoft Knowledge Base

File: Obtaining Unique Records from a Database with Duplicates

Last reviewed: October 27, 1994
Article ID: Q44020

Summary:

Microsoft File version 2.00 cannot extract unique records from a database that excludes duplicates. However, by following the steps below, the database can be taken into Microsoft Excel and the unique records extended and brought back into File:

  1. Close the Form window and choose List Helper (if you are not already in it) from the Form menu.
  2. From the File menu, choose Save Records As.
  3. Give the document a name, select Text, and click Save.
  4. Close File and open Excel.
  5. From the File menu, choose Open and open the text document saved from File.
  6. Select the first four rows, choose Insert from the Edit menu, and click OK.
  7. Select the titles of the database, and choose Copy from the Edit menu.
  8. Select A1 and choose Paste from the Edit menu.
  9. Select the first cell in row 1 after the last title name, then choose Paste again from the Edit menu.
  10. Select the database and field names, and choose Set Database from the Data menu.
  11. Select the field names in row 1 and the row below it, then choose Set Criteria from the Data menu.
  12. Select the extract range (the field names after the now set criteria, then choose Extract from the Data menu.
  13. Select Unique Records Only, then click OK.
  14. Select all the records in the extract range, and choose Copy from the Edit menu.
  15. Quit Excel and open the original database in File.
  16. Select the new line and choose Paste from the Edit menu.
  17. Select all the records above where you pasted in extract range and press BACKSPACE.

Additional reference words: M_eXceL export import transfer duplicate

KBCategory: kbusage
KBSubcategory:


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.

Last reviewed: October 27, 1994
©1997 Microsoft Corporation. All rights reserved. Legal Notices.