Microsoft KB Archive/44020

= 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.