To open a connection to your database and then open a table in the database:
- On the HOME tab, in the File group, click Open, and Table.
- In the Open dialog box, select the Open DBMS Connection button.
- If the Open DBMS Connection dialog box displays, select ODBC from the list and then click New.
- In the Select Data Source dialog box:
- Select the Machine Data Source tab.
- From the Data Source name list, select your connection name.
- Click OK.
You may see a login dialog box for your database connection. If you see this dialog, then provide the information required, such as user name and password for the database. For example, SQL Server users may see the following:
- In the Open dialog box schema and tables in your database display. If you do not see this, then from the Files of type list, select your data source name.
- Select the table to open from the list and click Open.
You are now ready to work with your table.