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.