You need to create a system DSN to the SQL Server. What does that mean? Under the Control Panel, you will have an ODBC Connectivity or a Data Source (ODBC) option. Here you will create the DSN to your SQL Server. Select the System DSN tab, select Add ... then select the SQL Server driver. Fill in the wizard. Then go back to Access and select File ... Get External Data ... Import. A dialog box will open. At the bottom, where there is a dropdown box for Files of Type ... select ODBC Databases. This will bring up the DSN selector. Again, select the System DSN tab ... then your SQL Server DSN that you just created. This will pop up a box where you will input your username and password BUT WAIT, don't hit OK, yet. You will see an Options ... button. After entering in your info, select this button. Here you can select which database you want to select from under your SQL Server. Now select OK, and another box will pop up listing all of the tables in the selected database for the selected SQL Server DSN.
HTH
