 | Import data from a database |
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. Compatible ODBC drivers are available from third-party vendors. For more information, see
ODBC drivers that are compatible with Excel for Mac
. For more information about installing ODBC drivers, see Microsoft Query
Help.
-
On the Data menu, point to Get External Data, and then click New Database Query.
-
Use Microsoft Query to connect to a data source and to create a query. When you have finished, click Return Data to import the data into Excel.
For more information about connecting to a data source and using Microsoft Query, see Microsoft Query Help.
-
In the Returning External Data to Microsoft Excel dialog box, do any of the following:
To
Do this
Choose query definition, refresh control, and data layout options
Click Properties.
Change the settings for a parameter query
Click Parameters.
Return the external data to the active sheet
Click Existing sheet. On your sheet, click the cell where you want to place the upper-left corner of the external data range, and then click OK.
Return the external data to a new sheet
Click New sheet, and then click OK.
Excel adds a new sheet to your workbook, and automatically pastes the external data range at the upper-left corner of the new sheet.
Create a PivotTable report by using the external data
Click PivotTable, and then click OK.
 | Notes |
|
