The following procedure describes how to access Vision or relative data from Access. This procedure was designed for users of Access Version 7.0. If you have Access97 or another version of Access, your steps may be slightly different, but the concepts will be the same.
To access data from Access:
1. Start Access.
2. Open an existing database or create a new one.
3. Select "Get External Data" from the File menu, then select "Import."
A dialog box displays.
4. Select "ODBC Databases" from the "Files of type:" list box and click "OK." A list box of data source names displays.
5. Select the DSN that you established for the data files of interest, and click "OK." (Click "New. . ." to create a new DSN. Refer to Section 3.1 Data Source Names (DSNs) for instructions.)
A list of the tables available in the selected data files displays.
6. Select the table or tables that you want to read into Access, and click the "OK" button. Click "Select All" to add all of the listed tables to your Access database.
The table name or names you selected display on the Access screen next to an icon of a table.
7. Double-click the table icon to open the table in Access.