When you have finished, click Return Data to import the data into Excel.įor more information about connecting to a data source and using Microsoft Query, see Microsoft Query Help. Use Microsoft Query to connect to a data source and to create a query. On the Data menu, point to Get External Data, and then click New Database Query.
For more information about installing ODBC drivers, see Microsoft Query Help.
#IMPORT EXCEL SPREADSHEET INTO QUICKBOOKS FOR MAC DRIVERS#
For more information, see ODBC drivers that are compatible with Excel for Mac. Compatible ODBC drivers are available from third-party vendors. To import data from a database, such as Microsoft SQL Server, you must have an ODBC driver that is compatible with Microsoft Query installed on your computer. 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.
0 kommentar(er)
