Viewing Data Exported into an Access Database

After you export data from Sage 300 into an Access database, you can view the data.

To view files exported to an Access database:

1. Open Access and create a new database file, then close Access, writing down the filename. (The extension will be MDB.)
2. Open the Sage 300 Export dialog box from the screen you are exporting data from.
3. Export the data from Sage 300 as explained in Exporting Data from Sage 300, choosing the Access file you created earlier.
4. Open the file in Access.

The Sage 300 data is displayed as new tables: double-click a table to view the exported data. Note that field values are displayed below a title line.