Microsoft KB Archive/103795

Mac Works: Import/Export Database to Mac FoxBase Plus

PSS ID Number: Q103795 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 =

To export Microsoft Works 2.0 and 3.0 Database files to FoxBase Plus for the Macintosh, first save the document to a text file, then import the file into FoxBase Plus.

Exporting from Works 3.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 or 4.0.
 * 2) From the File menu, choose Save As.
 * 3) Rename the file, choose File Format and select Text.
 * 4) Choose Save.

Exporting from 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.

Importing Database Files into FoxBase Plus
To import Database files into FoxBase Plus, do the following:


 * 1) Create new database headings in FoxBase Plus by choosing File from the New menu, selecting Database and Inserting field names.
 * 2) Give the FoxBase Plus database a new name, select a folder to save it into, and click Input Data Records Now Yes.
 * 3) Under the Database, select Append From.
 * 4) Click All Files, select the Works database and click From.
 * 5) The File Type selection should be Delimited With Tabs.
 * 6) Click Append.

Importing Files from FoxBase Plus to Works
To import files from FoxBase Plus 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, do the following:


 * 1) Open the Database in FoxBase Plus.
 * 2) From the Database Menu, select Copy To.
 * 3) Type a name and location of the new exported database.
 * 4) In the File Type box, select Delimited By Tabs.
 * 5) Click OK.

To import the database to Works 3.0 or 4.0, do the following:


 * 1) Open Works by double-clicking the icon.
 * 2) Click once on the database icon.
 * 3) Locate the database on the hard drive, using the scroll bar.
 * 4) Click Open, or double-click the database name.
 * 5) Works will prompt you with the Separate Database Fields By dialog box. Select Tabs and choose OK.

To import the database to Works 2.0, do the following:


 * 1) Open Works by double-clicking the icon.
 * 2) Click the Database icon.
 * 3) Click Import File to select the file.
 * 4) Locate the database on the hard drive using the scroll bar.
 * 5) Click Open, or double-click the database name.
 * 6) Works will prompt you with the Separate Database Fields By dialog box. Select Tabs and choose OK.

= MORE INFORMATION =

For more information, see pages 433-436 of the “Microsoft Works User’s Guide,” for version 3.0 and pages 397-408 of the version 2.0 “Microsoft Works User’s Guide.” Also see pages A-2, 8-10, and 8-13 of the “FoxBase+ User’s Guide.”

KBCategory: kbother KBSubcategory: macworkskb

Additional reference words: 2.00 3.00 mac mwksdb import export Foxbase AFE

=
========================================================= Version : 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbhowto ============================================================================= Copyright Microsoft Corporation 1998.