11 Replies Latest reply on Jun 7, 2017 6:50 AM by taylorsharpe

    Excel for Mac 2016 ODBC

    rossnicholson

      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.  The correct data source appears in the menu and I can select it.  But if I click "test" it or click "okay" to proceed Excel stops.

        • 1. Re: Excel for Mac 2016 ODBC
          mikebeargie

          This sounds like an excel issue, not a filemaker one. Did you make sure to use the correct ODBC drivers?

           

          However, when I am in Excel and begin a new database query Excel crashes every time.

          Did you mean when you are in FileMaker? How are you doing the query from within filemaker?

          • 2. Re: Excel for Mac 2016 ODBC
            taylorsharpe

            I have a Mac with OS 10.12.2 and Excel 15.30 and I just ran the Microsoft Update to confirm I have the latest version.  I have ODBC Manager 1.0.14 from Actual Technologies and I have run the FileMaker ODBC installer from the FMS install in the Extras (FMS  installer v 15.0.1).  I have created a System DSN for my database on a FileMaker 15.0.2 local server on our LAN (hosted on Mac OS X 10.12.2).  I have stepped through the wizard adding the System DSN and at the end I ran the test, put my credentials in, and it says the test ran successfully in ODBC Manager. 

             

            I go to Excel and click on the Data tab and "New Database Query" and select "From Database"  and it opens the iODBC Data Source Chooser.  I see my System DSN and click on it to highlight it and click the Test button and nothing happens.... nothing!  I then highlight it again and click the Configure button... it pauses briefly and the unhighlights the chosen datasource and does nothing.  Not being sure what to do, I click the "Add" button in iODBC and it pops up a window asking which driver you want to use.  I select "FileMaker ODBC" and hit Finish... and it returns to the same screen I had in iODBC manager with nothing... no choice of data source or anything. 

             

            I used to do a lot of these ODBC imports into Excel and never had problems.  I have the most current FileMaker and Microsoft Products. 

             

            I seem to be having the same problem Ross is having.  Are others seeing this too?

            • 3. Re: Excel for Mac 2016 ODBC
              taylorsharpe

              Oh, FYI, the FileMaker ODBC driver I am using on my Mac is version 14.0.9. 

              • 4. Re: Excel for Mac 2016 ODBC
                taylorsharpe

                Oh, since it was the last version, I upgraded to the FileMaker 15 driver (15.0.6) and the behavior has changed.  Instead of Excel doing nothing, after selecting a data source, it responds with "There was a problem and Microsoft Excel was closed.  We apologize for the inconvenience."  Oh great... its getting worse now.

                 

                FYI, this is what the crash gives the following in the attachment. 

                • 5. Re: Excel for Mac 2016 ODBC
                  rossnicholson

                  That is what my set up is doing.  I suspect it is an Excel issue but it is so intertwined with the ODBC drivers that I wasn’t sure where to begin.

                  • 6. Re: Excel for Mac 2016 ODBC
                    taylorsharpe

                    I cringe thinking about asking Microsoft for help in regards to a FileMaker ODBC driver.  I can see the finger pointing before I even call.  Of course I don't know it's not the FileMaker ODBC driver even though I suspect it is an Excel problem. 

                    • 7. Re: Excel for Mac 2016 ODBC
                      jwilson

                      I have a very similar set up (OS 10.12.5, Excel latest version, ODBC manager 10.0.14 from Actual, FM ODBC driver 13.2.4) and get exactly the same result - the connection tests OK under the ODBC manager, but, won't test, doesn,t cause MSQuery to launch and returns no data when used inside Excel (via Data/Get External Data/From Database, then selecting the connection from the iODBC chooser).

                       

                      If I use ODBC query software outside of Excel (iQueryODBC for example), it can see and read the data tables in the Filemaker database without problem.

                       

                      Did you get find a solution?

                      1 of 1 people found this helpful
                      • 8. Re: Excel for Mac 2016 ODBC
                        rossnicholson

                        Not yet.

                        • 9. Re: Excel for Mac 2016 ODBC
                          actualjon

                          The ODBC driver released with FM 16 is compatible with Excel 2016 for Mac:

                           

                          http://help.filemaker.com/app/answers/detail/a_id/12921

                           

                          The driver is unofficially backward compatible with FileMaker 11 and later.

                           

                          Jonathan

                          4 of 4 people found this helpful
                          • 10. Re: Excel for Mac 2016 ODBC
                            jwilson

                            YES, this finally cracked it, and I can now make ODBC connections from Excel (as client) to Filemker (as data source).

                             

                            I had tried with v14 and v15 of the ODBC drivers and neither worked but v16 seems to have corrected something.  I was 100% convinced that the isse was with Excel!.  Many thanks Jonathan

                             

                            At first glance it seems unusally slow, especially considering that both the database and Excel are on the same local machine.  But at least it works!

                             

                            My set up is:

                            MacBookPro 15" Touchbar 2016

                            OS: 10.12.5

                            Excel: 15.34 (via office 365 family subsription)

                            Filemaker: 13.0v9

                            Filemaker ODBC drivers: 16.0.1

                             

                               After many months of grief!!!

                            1 of 1 people found this helpful
                            • 11. Re: Excel for Mac 2016 ODBC
                              taylorsharpe

                              Thanks for letting us know, actualjon, and testing it out.  This sure was frustrating even though workarounds weren't hard.  Thanks!