Click here to go to the Office Update Home page   All Products  |   Support  |   Search  |   microsoft.com Guide  
Featured on Office UpdateMicrosoft
   Home   |    Auto Update   |    What's New   |    Search Office Update   |    eServices   |    Office Update Worldwide   |    Site Help   |
 

Moving Works 99 Data to Access 2000 Click here to email this to a friend.

You've decided it's time to move your data from Microsoft Works to Microsoft Access and you want to make sure the move goes smoothly. No problem. Here's your "moving guide" from Works 99 to Access 2000.

When you move data from one software product to another, you often need to convert the data from the old product to the new one. In this case, the move involves two basic steps:

  1. Export the data from Works to an external format supported by both products.
  2. Import the data into Access.

To move data from a Works database into Access, you export the data to either dBASE (*.dbf) or text (*.txt) file format, and then import the data into Access using the appropriate format. Unlike text format, the dBASE format preserves most field names. If you do import a text file into Access, you can either define field names in the Import Text Wizard, or modify the default field names in Design view of the table.

To move data from a Works spreadsheet into Access, you export the data to Lotus 1-2-3 (*.wk1) file format, and then import the data into Access. When you import a Lotus 1-2-3 file into Access, you can either define field names in the Import Spreadsheet Wizard, or modify the default field names in Design view of the table.

Once your data is in Access, you can quickly become productive in your new database by using the many wizards Access provides to create forms, reports, and data access pages.

Resource Finder

Use the following table to decide which task is most appropriate for your needs, and then find the step-by-step, troubleshooting, or conceptual information that will help you accomplish the task.

For information about Read the following Web article, Access 2000 Help topic, or Works 99 Help topic
Moving a Works database in dBASE format into Access
Moving a Works database in text format into Access
  • Works Help topic: To save a Works document as a text file
  • Access Help topic: Import or link a delimited or fixed-width text file
  • Access Help topic: Troubleshoot text or spreadsheet import errors
Moving a Works spreadsheet in Lotus 1-2-3 format into Access
Learning about other related tasks in Works and Access

 
    What did you think?UsefulNot UsefulThank you for your vote!Thank you for your vote and feedback!
 
é

© 2000 Microsoft Corporation.
All rights reserved. Terms of use.  Disclaimer.