Moving Works data to Access

Applies to
Microsoft Access 2000

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

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 Help topic, or Works Help topic
Moving a Works database in dBASE format into Access
  • ACC2000: How to Import a Works Database into Microsoft Access (Q197894)
  • Works: How to Import a Works Database into Microsoft Access (Q154167)
  • ACC: Error When Importing dBASE, FoxPro, or Paradox Table (Q95327)
  • Access Help topic: Import or link dBASE files
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
  • ACC2000: How to Import Spreadsheets from MS Works for Windows (Q209726)
  • ACC: How to Import Spreadsheets from MS Works for Windows (Q93698)
  • Access Help topic: Troubleshoot text or spreadsheet import errors
  • Access Help topic: Import or link data from a spreadsheet
Learning about other related tasks in Works and Access
  • Works for Windows Frequently Asked Questions
  • Converting Works Files
  • Works Help topic: To save a Works document in another program's format
  • Access Help topic: Import or link data and import database objects