MS SQL Server Interview Question:

How To Connect MS Access to SQL Servers through ODBC?

Submitted by: Administrator

Once you got a DSN defined in the ODBC manager that connects to your SQL Server, you can connect a normal MS Access document to the Oracle server, and link an Access table to a SQL Server table. The tutorial below gives you a good example:

* Start MS Access with a new database file.
* Go to File menu.
* Select Get External Data.
* Select Import.... The Import dialog box shows up.
* Select Files of type: ODBC Database(). The Select Data Source dialog box shows up.
* Click the Machine Data Source tab. You should see the DSN name "ggl_SQL_SERVER" you defined earlier.
* Select "ggl_SQL_SERVER".
* Enter User Name: sa.
* Enter Password: GlobalGuideLine.

Click the OK button to continue. You should see a list of tables available for you to import from the SQL Server as shown in the picture below:
MS Access importing tables via ODBC

Select the table you are interested in and click OK. You should the selected table being imported from the SQL Server to MS Access.
Submitted by: Administrator