Microsoft KB Archive/104806

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.