UPDATED:
We were having the same issue and it was related to a bug in the ActualTech ODBC package. They have since posted an update on their website here:
http://www.actualtech.com/download.php
After installing the update, we were back in action.
Nvidia enthusiasts platform kdm drivers for mac. Since I'm on a Mac, I'm having to use the Actual Technologies ODBC driver for Mac. I guess it must be a limitation in the Actual Technologies driver. Bummer, but thanks for confirming it works on a Windows computer with FileMaker.
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: OpenLink Software. Actual Technologies. MAC EXCEL 2016 ODBC Hi, I am developing a Excel VBA application using a.xlsx workbook as database. I will contact Actual Technologies. Thank you for the advice.
I am not sure this is the whole source of the problem, despite Microsoft's articles.. Samsung printer drivers for mac.
I just downloaded and installed v4.0 of the Actual Open Source Database drivers, and they appear to BE 64bit..
Looking at the ODBC driver:
$ lipo -info 'Actual Open Source Databases' Hp printer drivers for mac.
Architectures in the fat file: Actual Open Source Databases are: i386 ppc7400 x86_64 ppc64
I do have others installed, not all of which might be 64bit, but in your case if Actual is the only one installed and you are on the latest release it should be 64bit capable.
There are no current Macs with these cards, so support is absent natively in OS X. These are separate from the drivers Apple ships as standard, and should be considered experimental. NOTE: These drivers are currently the only method to get full acceleration for NVIDIA GeForce GTX 750, 750 Ti, 950, 960, 970, 980, 980 Ti, and TITAN X 'Maxwell' graphics cards. Ati 8.12 driver for mac. NVIDIA has released alternate graphics drivers for OS X El Capitan 10.11.6. These drivers have been known to solve OpenCL issues with certain applications, as well as providing better native GPU power management for certain devices.
UPDATE: In fact, all but one of my installed ODBC drivers WERE 64bit, so I removed the onlly one that was not and the same crash happens. I don't think the 64bit issue is the entire answer to the problem this latest office update has inflicted on us.
Ok so I called into their support line and they were able to give me an installer for the 32 bit version of Excel. I'd recommend you do the same if you need the functionality now.
BTW chat was a no-go for this, I had to call.
I'd post the link here but they also removed some other things manually in order to completely remove Office 2016 before re-installing. I think its safer to have them do that.
Regarding the error the exception I was getting looks like this:
Crashed thread: 0
It references iODBC, which I believe is the first ODBC manager Excel attempts to use prior to prompting you to use the ODBC manager that comes w/ the Actual package.
I'm not sure if iODBC is installed w/ Excel or Actual.
We have discovered that our driver has an issue with the August (64-bit) release of Excel 2016. We will be releasing a fix within the next 48 hours.
I will post here when the new version has been released.
UPDATE: we have posted a new version of the Actual ODBC Pack to our website: http://www.actualtech.com/download.php
The new versions of the ODBC drivers fix the crashing issue with 64-bit Excel 2016 (15.25).
Jonathan Monroe
Actual technologies - ODBC for macOS
http://www.actualtech.com
I see an update posted, and after I installed it Excel 2016 64bit (15.25 (160817)) is no longer crashing when I attempt to insert data from an external database.
Thanks!!
Hi, here is the information we have on this issue, I hope it helps. If you continue to experience problems after installing a compatible driver, please let us know.
Issue
When retrieving data via Data > Get External Data > From Database from an external database that uses a 32-Bit ODBC driver, the 64-Bit Excel 2016 for Mac (version 15.25 or later) crashes
Status: Workaround
This is a known compatibility issue. Please visit this article ODBC drivers that are compatible with Excel for Mac and install a driver that includes 64-bit support.
See Also
Freya
Office Newsroom