Others

How to Convert an Old MS Works Database to Microsoft Access

Maira Mehtab Sep 27, 2026 871 views

Question details

The user needs to preserve and migrate a legacy MS Works database from the early 1990s into a modern Microsoft Access database format.

Product: MS Works, Microsoft Access
Device & OS: not provided
Scenario: Upgrading and migrating an outdated database still used for daily account entry to a modern, supported platform.
Observed behavior: The original data is trapped in an obsolete MS Works format, requiring extraction, restructuring, and normalization to function properly in Microsoft Access.

Before you start

Ensure you have a secure backup of your original MS Works database file and verify that you have access to a machine that can still run the legacy MS Works software for the initial export.

Solution 1Recommended

Export MS Works Data to CSV and Import into Access

The most reliable method involves exporting the legacy data into a universal format and restructuring it inside Microsoft Access.

Since modern versions of Microsoft Access cannot natively open legacy MS Works database files, the data must first be converted into an intermediary format like CSV. Once imported into Access, the raw flat-file data can be reorganized into properly structured, normalized tables.

Export to CSV format

Open your database in MS Works, click on 'File' > 'Save As' or 'Export', and choose the CSV (Comma Separated Values) or Text format to extract the raw data.

Import raw data into Access

Open Microsoft Access, create a blank database, navigate to the 'External Data' tab, click 'New Data Source', select 'From File' > 'Text File', and follow the wizard to load your CSV into a non-normalized, temporary table.

Design normalized tables

Using the 'Create' tab in Access, build new, empty tables that separate your data logically (e.g., separate tables for Customers, Products, and Orders) and establish relationships between them.

Populate tables using Append Queries

Use Append Queries to move data from the temporary flat table into your new normalized tables. Ensure you populate reference tables (like Customers and Products) before populating dependent tables (like Orders and OrderDetails) to maintain referential integrity.

Data Cleansing: It is highly recommended to open the exported CSV file in a spreadsheet application to clean up invalid characters or misaligned columns before importing it into Microsoft Access.

Solution 2

Hire a Database Migration Specialist

For damaged files, highly complex databases, or instances where technical expertise is lacking, hiring a professional developer is the safest route.

Free Microsoft Office alternative

Clean Your Exported Database CSVs with WPS Office

When converting legacy databases, you need a robust spreadsheet application to review, clean, and organize your CSV files before importing them into a new database system. WPS Office is a lightweight, completely free alternative that seamlessly handles CSV and Microsoft Excel formats.

1. Download and Install: Download WPS Office Free from the official website and follow the simple installation instructions.
2. Open your CSV file: Launch WPS Spreadsheet, go to 'Menu' > 'Open', and select the CSV file exported from your old MS Works database.
3. Clean the data: Use built-in data sorting, filtering, and text-to-columns tools to prepare and clean your data for a flawless Microsoft Access import.

Fully compatible with Microsoft Excel formats including XLSX, XLS, and CSV.Easily open, review, and clean up massive data sets exported from MS Works.Lightweight software with a familiar, user-friendly interface.A completely free alternative for your spreadsheet and document editing needs.

microsoft office alternative - wps office

Frequently Asked Questions

Why do I need to export the MS Works database to CSV first?

MS Works relies on an outdated, proprietary file format (like .wdb) that modern versions of Microsoft Access and other database platforms cannot read natively. Converting to a CSV (Comma Separated Values) file translates the database into a universal text format that any database system can import.

What does normalizing tables in Microsoft Access mean?

Normalization is the process of organizing data to minimize redundancy and improve data integrity. Instead of having one massive spreadsheet where customer details are repeated on every order, normalization splits the data into related tables (e.g., a 'Customers' table and an 'Orders' table) linked by unique IDs.

Why must I import reference tables before dependent tables?

In a relational database, dependent tables rely on the data in reference tables. For example, you cannot assign an order to a customer in the 'Orders' table if that customer does not yet exist in the 'Customers' table. Populating reference tables first prevents referential integrity errors during the import process.

What should I do if my MS Works file won't open to export the data?

If the file is damaged, corrupted, or you no longer have access to a computer running MS Works, standard export methods may fail. In such cases, it is highly recommended to hire a specialized database migration expert who possesses specialized extraction software to recover data from legacy files.

Office Quick Solutions