Microsoft KB Archive/60150

= Microsoft Knowledge Base =

File: Transferring to and from FileMaker II
Last reviewed: October 27, 1994

Article ID: Q60150

Summary:

To output FileMaker II version 1.0 data to Microsoft File in Text format, do the following:

  Open the FileMaker file that contains the data to be copied to the output file. If the file is already open, make it the current file by choosing it from the Window menu. Do one of the following, depending on how you want to output the records: a. To output only a subset of the records, use the Find command or the Omit Records command to select the records. -or- b. To output the records in sorted order, use the Sort command to sort the records. -or- c. To output values using number and data formats from the layout, make sure the fields on the current layout have the formatting desired.   On the Browse screen, choose Output To from the File menu. FileMaker displays a dialog box that asks for information about the output file to be created.  Type a name for the output file and specify where it is to be stored. If necessary, change the directory or disk. Click the New button. Click the check box for Text File (Tabs) format. Click the Move All button (this must be done to activate the Output button). Click the Exclude button to transfer data without calculations. Otherwise, click Include. Click the Output button to copy the data to the output file.</li> Open a new data file in Microsoft File.</li> Using the form window, create all the fields necessary to import from the FileMaker II output file.</li> Close the form window.</li> From the File menu, choose Open data file and select the FileMaker II output file.</li></ol>

To transfer a data file from Microsoft File to Claris FileMaker II versions 1.0, 1.1, and 1.2.1, the data file must be saved as text:


 * 1) Load the desired data file into Microsoft File.
 * 2) From the File menu, choose Save Records As.
 * 3) Give the data file a new name, select Text, and click Save.

The Microsoft File data file is now saved as a tab-delimited text file that can be read into FileMaker II. To import this text file into FileMaker II, follow the steps on pages 320-324 &quot;Copying Data from Text, BASIC, or SYLK Files to FileMaker,&quot; in the &quot;FileMaker II&quot; version 1.0 manual.

If you need additional assistance to transfer the data file into FileMaker II, call Claris Technical Support at (408) 727-9054.