Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Connecting MS Access to SQL Servers through ODBC

By: FYIcenter.com

(Continued from previous topic...)

How To Connect MS Access to SQL Servers through ODBC?

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 "FYI_SQL_SERVER" you defined earlier.
• Select "FYI_SQL_SERVER".
• Enter User Name: sa.
• Enter Password: FYIcenter.

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:
   

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

(Continued on next topic...)

1. What Is Open Database Communication (ODBC)?
2. How To Add a New DSN with the ODBC Driver for SQL Server?
3. How To Define the Name and Server for a new DSN?
4. How To Provide Login Information for a New ODBC DSN?
5. Why Are You Getting Errors When Creating a New ODBC DSN?
6. What Are the Requirements on SQL Server Network Connections?
7. How To Start SQL Server Browser Service?
8. How To Enable TCP/IP Protocol on a SQL Server?
9. How To Verify the Port Number of the SQL Server?
10. How To Configure ODBC DSN with Different Port Numbers?
11. How To Configure and Test ODBC DSN Settings?
12. How To Connect MS Access to SQL Servers through ODBC?
13. How Can Windows Applications Connect to SQL Servers via ODBC?