Microsoft KB Archive/103797

Mac Works: Export/Import Database to/from Access

PSS ID Number: Q103797 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 files to Microsoft Access for Windows, save the document as a text file, load the file to an MS-DOS-formatted floppy disk using Apple File Exchange, then import the file into Access.

= SAVING THE DATABASE FILE IN WORKS 3.0 OR 4.0 AS A TEXT FILE =

To save the Database file in Works 3.0 or 4.0 as a text file, 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, click File Format, and select Text.
 * 4) Click Save.

= SAVING THE DATABASE FILES IN WORKS 2.0 AS A TEXT FILE =

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


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

= LOADING THE DATABASE FILE TO AN MS-DOS FORMATTED DISK =

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


 * 1) Start Apple File Exchange. Apple File Exchange can be found on the system disks if it’s not installed.
 * 2) Insert the MS-DOS-formatted floppy.
 * 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 THE DATABASE FILE INTO ACCESS =

To import the Database file into Access, follow these steps:


 * 1) Open the Database file or switch to the Database window in an open database.
 * 2) From the File menu, choose Import.
 * 3) In the Data Source list box, select Text (Delimited), and click OK. Access displays the Select File dialog box.
 * 4) Select the text file to import from the floppy disk, and click Import.
 * 5) Click Options.
 * 6) In the File Type list box, select Windows (ANSI).
 * 7) In the Text Delimiter box, select {none}.
 * 8) In the Field Separator box, select {tab}.
 * 9) Click OK.

= IMPORTING FILES FROM ACCESS TO WORKS =

To import files from Access to Works, export the table as text, load the file to a Macintosh using Apple File Exchange, then import the file into Works.

= EXPORTING THE ACCESS FILE AS A TEXT FILE =

To export the Access file as a text file, follow these steps:


 * 1) Switch to the Database file containing the table to be exported.
 * 2) From the File menu, choose Export.
 * 3) From the Data Destination list box, select Text (Delimited) and click OK.
 * 4) From the Tables box, select the table to export and click OK.
 * 5) Enter the filename of the text file to export to and click OK.
 * 6) Click Options.
 * 7) In the File Type list box, select Windows (ANSI).
 * 8) In the Text Delimiter box, select {none}
 * 9) In the Field Separator box, select {tab}.
 * 10) Click OK.

= LOADING THE DATABASE FILE TO THE MACINTOSH USING APPLE FILE EXCHANGE =

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


 * 1) Start Apple File Exchange. 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 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.

= IMPORTING THE DATABASE FILE TO MICROSOFT WORKS 3.0 OR 4.0 =

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) Under the File Format list box choose All Available.
 * 4) Locate the Database file on the hard drive, using the scroll bar.
 * 5) Click Open or double-click the Database filename.
 * 6) When the Separate Database Fields By box appears, select Tabs and click OK.

= IMPORTING THE DATABASE FILE TO MICROSOFT WORKS 2.0 =

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


 * 1) Open Works by double-clicking the Works icon.
 * 2) Click the Database icon once.
 * 3) Click Import File.
 * 4) Locate the Database file on the hard drive, using the scroll bar.
 * 5) Click Open or double-click the Database filename.
 * 6) When the Separate Database Fields By box appears, select Tabs and click OK.

For more information, please refer to the following:


 * “Microsoft Works User’s Guide,” for version 4.0, pages 605-608
 * “Microsoft Works User’s Guide,” for version 3.0, pages 433-436
 * “Microsoft Access User’s Guide” for version 1.0, pages 75-85
 * “Microsoft Access User’s Guide” for version 2.0, pages 175-194

= REFERENCES =

“Microsoft Access User’s Guide”, Chapter 4, “Importing, Exporting, and Attaching,” page 75-78 and 84-85.

KBCategory: kbother KBSubcategory: macworkskb

Additional reference words: 2.00 3.00 mac import export AFE mwksdb

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