Microsoft KB Archive/103796

Mac Works: Import/Export FoxPro Databases

PSS ID Number: Q103796 Article last modified on 10-22-1998

2.0 2.5 2.5b 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
• Microsoft FoxPro for Windows, version 2.5
• Microsoft FoxPro for MS-DOS, version 2.5
• == Microsoft FoxPro for the Macintosh, version 2.5b ==

SUMMARY

To export a Works file to FoxPro, save the document to a text file, load the file to an MS-DOS-formatted floppy disk by using Apple File Exchange (AFE), then import the file into FoxPro. This article explains this procedure.

MORE INFORMATION

Saving Database Files in Works 3.0 as Text Files

To save Database files in Works 3.0 or 4.0 as text files, follow these steps:

1. Open the Database file in Works 3.0 or 4.0.
2. From the File menu, choose Save As.
3. Give the file a new name, then click File Format and select Text.
4. Click Save.

Saving Database Files in Works 2.0 as Text Files

To save Database files in Works 2.0 as text files, follow these steps:

1. Open the Database file in Works 2.0.
2. From the File menu, choose Save As.
3. Give the file a new name, then click Export File.
4. Click Save.

Copying the Database File to a Disk

To copy the Database file to an MS-DOS 3.5-inch formatted disk, follow these steps:

1. Start Apple File exchange by clicking it. Apple File Exchange can be found on the system disks if it’s not installed.
2. Insert the MS-DOS-formatted floppy disk.
3. From the Mac To MS-DOS menu, choose Default Translation.
4. Locate the file on the hard drive and click once to select it.
5. Click the Translate button.
6. When the translation is done, eject the disk by clicking the Eject button.
7. From the File menu, choose Quit.

Importing a Database File in to FoxPro

To import a Database file in to FoxPro, follow these steps:

1. Create a new database heading in FoxPro by choosing New from the File menu, and inserting the field names.
2. From the Database menu, choose Append From.
3. Click From and select the database.
4. In the File Type box, select Delimited With Tabs.
5. Click Append.

Importing Files from FoxPro to Works

To import files from FoxPro to Works, first save the file as a text file, load the file to a Macintosh by using Apple File Exchange, then import the file into Works.

To save the Database file to a tab-delimited text file, follow these steps:

1. Open the Database in FoxPro.
2. From the Database menu, choose Copy To.
3. Type the name and location of the new exported database.
4. In the File Type box, select Delimited By Tabs.
5. Choose OK.

To load the Database file to the Macintosh using Apple File Exchange, follow these steps:

1. Start Apple File Exchange by clicking it. Apple File Exchange can be found on the system disks if it’s not installed.
2. Insert the MS-DOS-formatted floppy disk containing the Database file.
3. From the MS-DOS To Mac menu, choose Default Translation.
4. Locate the file on the floppy disk drive and click once to select it.
5. Open or create a folder to hold the Database file.
6. Click the Translate button.
7. When the translation is done, eject the disk by clicking the Eject button.
8. From the File menu, choose Quit.

To import the Database file to Microsoft Works 3.0 or 4.0, follow these steps:

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

To import the Database file to Microsoft Works 2.0, follow these steps:

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

KBCategory: kbother KBSubcategory: macworkskb

Additional reference words: Works 2.00 3.00 FoxPro mac mwksdb import export AFE ms-dos formatted

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