I have Excel for Mac 2016 (version 15.30 -- 64 bit) and am trying to establish database query to a Filemaker Pro 15 file on hosted Filemaker Server 15. I believe I have created the DSN correctly thru ODBC Manager as I can run the 'test' successfully. However, when I am in Excel and begin a new database query Excel crashes every time. To connect a new or existing Excel 2016 spreadsheet to an OpenEdge database using a previously configured ODBC data source: • Open Excel. • Open the existing document or create a new document • From the main menu, click 'Existing Connections'. • If a connection to the desired OpenEdge database is listed in the Connections tab, select it and click Open. Otherwise, click 'Browse for More.' • Click 'New Source.' • In the Data Connection Wizard, select 'ODBC DSN' and click Next. • Select ODBC data source for the desired OpenEdge database from the list. • Verify the connection information in the Logon dialog and click OK. • Select a table from the list or deselect the 'Connect to a specific table: check box, then click Next. • Enter a name and other descriptive information for the Data Connection file that will be created, and click Finish to save it. In 32-bit Excel, only data sources using 32-bit OpenEdge ODBC drivers will be listed by the Data Connection Wizard. Similarly, 64-bit Excel will only list data sources using 64-bit drivers. See the references below for information on obtaining the correct OpenEdge ODBC driver and configuring an OpenEdge database as an ODBC data source. References to Other Documentation: OpenEdge Data Management: SQL Development, Chapter 3, 'ODBC Client > Configuring data sources > Configuring Windows clients' Microsoft Office Support: Connect external data to your workbook Progress Articles: 000026096, 000011121, 000015033, 000020494. Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information. Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an 'AS IS' basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages. Are there add-ins available? Even from a third-party? Hope these download links helps? Quoted from the MSKB in case the link dies ODBC drivers that are compatible with Excel for Mac If you want to import data into Excel for Mac from a database, you need an Open Database Connectivity (ODBC) driver installed on your Mac. The driver you get depends on which version of Excel for Mac you have. Excel for Mac 2011 This version of Excel does not provide an ODBC driver. You must install it yourself. ![]() ![]() Drivers that are compatible with Excel for Mac 2011 are available from these companies: After you install the driver for your source, you can use Microsoft Query to create new queries or refresh existing queries that were created in other versions of Excel, such as Excel X, Excel 2004, and Excel for Windows. For more information, see. Excel 2016 for Mac This version of Excel does provide an ODBC driver for connecting to SQL Server Databases. On the Data tab, click New Database Query > SQL Server ODBC. Then use the dialog boxes to import the data. If you are connecting to other ODBC data sources (for example, FileMaker Pro), then you’ll need to install the ODBC driver for the data source on your Mac. Drivers that are compatible with Excel for Mac are available from these companies: Has anyone gotten this to work? Sorry, I have never used it.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |