Mac Works: Import/Export Database to FileMaker Pro
  
PSS ID Number: Q104806
Article last modified on 10-22-1998
 
2.0 3.0 4.0
 
MACINTOSH
 

======================================================================
-----------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Works for the Macintosh, versions 2.0, 3.0, and 4.0
-----------------------------------------------------------------
 
SUMMARY
=======
 
This article discusses exporting and importing Database files between Works
for the Macintosh and FileMaker Pro.
 
EXPORTING FILES FROM WORKS TO FILEMAKER PRO
===========================================
 
To export Microsoft Works Database files to FileMaker Pro for the
Macintosh, first save the document to a text file, then import the file
into FileMaker Pro.
 
For Works 3.0 and 4.0
---------------------
 
To export Database files from Works 3.0 or 4.0 to a text file, do the
following:
 
1. Open the Database file in Works 3.0.
 
2. Form the File menu, choose Save As.
 
3. Rename the file, choose File Format, and select Text.
 
4. Choose Save.
 
For Works 2.0
-------------
 
To export Database files from Works 2.0 to a text file, do the following:
 
1. Open the Database file in Works 2.0.
 
2. From the File menu, choose Save As.
 
3. Rename the file and select Export File.
 
4. Choose Save.
 
To import Works Database text files into FileMaker Pro, do the following:
 
1. Open FileMaker Pro and create a Database with the same field names as
   the Works Database.
 
2. In Browse, choose Import/Export from the File menu and select Import
   Records.
 
3. From the File Type list, choose Tab-Separated Text.
 
4. Select the name of the Works Database.
 
5. Click Open.
 
6. Select Add New Records.
 
7. Click OK.
 
IMPORTING FILES FROM FILEMAKER PRO TO WORKS
===========================================
 
To import files from FileMaker Pro to Works, first export the file to
a text file, then import the file into Works.
 
To export the Database to a tab-delimited text file, follow these steps:
 
1. Open the FileMaker Pro Database.
 
2. In Browse, choose Import/Export from the File menu and select Export
   Records.
 
3. Type the name for the destination file and specify the location.
 
4. Choose Tab-Separated Text from File Type.
 
5. Click New.
 
6. Select Don't Format Output.
 
7. Click OK.
 
To import the database to Works 3.0 or 4.0, follow these steps:
 
1. Open Works (or if Works is open, choose Open from the File menu).
 
2. Click the Database icon once.
 
3. Locate the database on the hard drive using the scroll bar and click to
   select it.
 
4. Click Open.
 
5. Works version 3.0 only will prompt with "There is no translator
   available..." Click OK.
 
6. Works will prompt with the "Separate Database Fields by:" message.
   Select Tabs. Click OK.
 
To import the database to Works 2.0, follow these steps:
 
1. Open Works, or if Works is open, choose Open from the File menu.
 
2. Click the Database icon once.
 
3. Click Import File.
 
4. Locate the Database on the hard drive using the scroll
   bar and click to select it.
 
5. Click Open.
 
6. Works will prompt with "There is no translator available..." Click
   OK.
 
7. Works will prompt with the "Separate Database Fields by:"
   Select Tabs. Click OK.
 
FileMaker Pro is manufactured by a vendor independent of Microsoft; we make
no warranty, implied or otherwise, regarding this product's performance or
reliability.
 
REFERENCES
==========
 
"Microsoft Works User's Guide," for version 4.0, pages 605-608
 
"Microsoft Works User's Guide," for version 3.0, pages 433-436
 
"Using Microsoft Works," for version 2.0, pages 397-408
 
Claris "FileMaker Pro User's Guide," pages 8-3, 8-16
 
Additional query words: 2.00 3.00 mac mwksconv 3rdparty file maker
 
======================================================================
Version           : 2.0 3.0 4.0
Platform          : MACINTOSH
Issue type        : kbhowto
=============================================================================
Copyright Microsoft Corporation 1998.