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:
- Close the Form window and choose List Helper (if you are not already in it) from the Form menu.
- From the File menu, choose Save Records As.
- Give the document a name, select Text, and click Save.
- Close File and open Excel.
- From the File menu, choose Open and open the text document saved from File.
- Select the first four rows, choose Insert from the Edit menu, and click OK.
- Select the titles of the database, and choose Copy from the Edit menu.
- Select A1 and choose Paste from the Edit menu.
- Select the first cell in row 1 after the last title name, then choose Paste again from the Edit menu.
- Select the database and field names, and choose Set Database from the Data menu.
- Select the field names in row 1 and the row below it, then choose Set Criteria from the Data menu.
- Select the extract range (the field names after the now set criteria, then choose Extract from the Data menu.
- Select Unique Records Only, then click OK.
- Select all the records in the extract range, and choose Copy from the Edit menu.
- Quit Excel and open the original database in File.
- Select the new line and choose Paste from the Edit menu.
- Select all the records above where you pasted in extract range and press BACKSPACE.
Additional reference words: M_eXceL export import transfer duplicate Last reviewed: October 27, 1994 |