To ensure the connection is working, enter some data, and then select Data > Refresh All.
After you import the data, you can also select Data > Connections, and then in the Connection Properties dialog box, select Properties. To set connection properties on the Usage and Definition tabs of the Properties dialog box, select Properties. When you're ready, select Return Data. The Import Data dialog box appears.Ĭhoose where you want the data to be added: either on the existing sheet, on a new sheet, or in a PivotTable. You can change the SQL statement as you see fit. In the left pane, navigate to the table you want, and then select it.Ĭonfirm the SQL statement on the right pane. Under Authentication, select a method from the list: Username/Password, Kerberos, or NTLM.Įnter credentials in the User Name and Password boxes. Get this information from the database administrator. Select Data > Get External Data > New Database Query > SQL Server ODBC. The Connect to SQL Server ODBC Data Source dialog box appears.Įnter the server in the Server Name box, and optionally, enter the database in the Database Name box.