Microsoft KB Archive/44554

Microsoft Knowledge Base

File: Copying Records by Position

Last reviewed: October 27, 1994
Article ID: Q44554

Summary:

In Microsoft File, instead of retyping information in one record that is similar to another, copy the record or records into the Clipboard, then paste the copy into the same or a different data file. File allows you to copy a single record or group of records by name or position. Copy by position is only available when pasting the records into a different data file. If the records are pasted into the same data file, File will automatically copy by name.

To copy by position, do the following:

1. Select the record or records you want to copy.
2. From the Edit menu, choose Copy.
3. Close the data file.
4. From the File menu, choose Open Datafile and open the data file in which the records are to be pasted.
5. Highlight the New record.

6. From the Edit menu, choose Paste.

   Note: If you are using a version of File earlier than 2.00, select Position in the Position dialog box and click OK.

More Information:

When you copy by position in a version of File earlier than 2.00, the application copies the contents of a field in the original data file to the field in the same position in the new data file. File ignores field names, pasting in order from left to right, top to bottom. If File does not find a field in a matching position, the contents of the field are discarded. If the information types do not match, File displays "#ERROR" in the field instead of the pasted value. Use this method when the field positions in the two files match.

If you close the data file, open a different data file, and paste from the Clipboard, File displays the Position dialog box, which allows you to choose Paste By Position or Paste By Name.

Additional reference words: datafile 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.