Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - Connecting MS Access to SQL Servers through ODBC
(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...)
- What Is Open Database Communication (ODBC)?
- How To Add a New DSN with the ODBC Driver for SQL Server?
- How To Define the Name and Server for a new DSN?
- How To Provide Login Information for a New ODBC DSN?
- Why Are You Getting Errors When Creating a New ODBC DSN?
- What Are the Requirements on SQL Server Network Connections?
- How To Start SQL Server Browser Service?
- How To Enable TCP/IP Protocol on a SQL Server?
- How To Verify the Port Number of the SQL Server?
- How To Configure ODBC DSN with Different Port Numbers?
- How To Configure and Test ODBC DSN Settings?
- How To Connect MS Access to SQL Servers through ODBC?
- How Can Windows Applications Connect to SQL Servers via ODBC?