Add Your Tables

  1. Click the table or tables that you want to read into Access and click OK. Click Select All to add all of the listed tables to your Access database. In Access 2007, The Get External Data - ODBC Database dialog box appears. Select the Save import steps checkbox if you wish, and click Close.
  2. Double-click the table icon to open the table in Access. If you have imported the data, the table name or names you selected appear on the Access screen next to an icon of a table. You will see a different icon next to the table names if you have linked the data.
  3. You may now perform Access operations on this data.