Important: As of August 2016, Excel 2016 for the Mac was updated from 32-bit software to 64-bit software. To see if you have this update, click the Excel menu > About Excel. If you have version 15.25 or later, you have the 64-bit version. The 64-bit update helps Excel run faster, and makes it more reliable when working with very large files. However, if you are using a 32-bit ODBC driver from one of the companies listed above, it may cause Excel to crash when connecting.
Dec 30, 2016 I am having trouble connecting to a SQL Server (2008 R2) via the new Excel 2016 for Mac SQL Server ODBC New Database Query feature. We also have another SQL Server (SQL Server Express 2012) that I also access via ODBC on Windows Excel 2016. Microsoft Excel on the Mac is also quite popular and many of us have wondered when Microsoft will come out with a full version of Pivot Tables on Mac Excel. The Simba ODBC drivers on the Mac include Hive, HBase, Cassandra, and MongoDB.
To avoid this, install a 64-bit driver from the company’s website.
Connect to an external data source You can use an external data source, but it depends on the type of source. If the source is a SQL Database • On the Data tab, click New Database Query • Click SQL Server ODBC. • The Connect to SQL Server ODBC Data Source dialog box appears. Get the server information from your database administrator, and type it in this dialog box. Click Connect when you're done.
• On the left, click the arrow next to the server to see the databases. • Click the arrow next to the database you want. • Then click the name of the table you want. • To get a preview of what the data will look like, click Run.
• When you're ready to bring the data into Excel, click Return Data. • In the Import Data dialog box, choose where you want the data to be: either on the existing sheet, on a new sheet, or in a PivotTable. Then click OK.
If the source is not a SQL Database If you want to use an external source that is not a SQL Database (for example, FileMaker Pro), you will need an Open Database Connectivity (ODBC) driver installed on your Mac. Information on drivers.
Once the driver for your source is installed, you can follow these steps to use the data: • On the Data tab, click New Database Query • Click From Database. • Add the data source for your database, and then click OK. • On the left, click the arrow next to the server to see the databases.
• Click the arrow next to the database you want. • Then click the name of the table you want. How to enable vba editor in excel 2016 for mac download. • To get a preview of what the data will look like, click Run.
• When you're ready to bring the data into Excel, click Return Data. • In the Import Data dialog box, choose where you want the data to be: either on the existing sheet, on a new sheet, or in a PivotTable. Then click OK. 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.
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 by using the external data Click PivotTable, and then click OK. Notes: • Excel 2011 for Mac cannot import data from OLE DB or OLAP data sources.