Thanks Tim. MS sent me an email saying:
"The best place to ask this question is the Excel area of answers.microsoft.com <http://answers.microsoft.com/>, which I know you've done already. We monitor that forum and we've got the right folks over there who can help with questions like this, so I'm going to go ahead and remove this idea from UserVoice (since we're trying to keep the UserVoice site for new product ideas)." So they’ve deleted the suggestion that they get MS Excel to accept data from MS Query. Anyway, spent 2 hours on phone with tech support to no avail this morning. The guy even connected to my machine with LogMeIn Rescue to see the problem. But he hadn’t even heard of Microsoft Query, and even thought it must be a third party product, despite the name! Gory details are here: http://answers.microsoft.com/en-us/mac/forum/macoffice2016-macexcel/odbc-connection-not-working-within-excel/e6ac7984-904b-4a85-9a7e-f2bb8eeb75b5?auth=1 <http://answers.microsoft.com/en-us/mac/forum/macoffice2016-macexcel/odbc-connection-not-working-within-excel/e6ac7984-904b-4a85-9a7e-f2bb8eeb75b5?auth=1> Thanks, James. > On 9 Sep. 2016, at 8:21 am, Timothy Penner <[email protected] > <mailto:[email protected]>> wrote: > > Hi James, > > I tried voting but the MS Feedback link you provided returns the following > message: > "This idea has been converted to a private support message" > > From this link: > https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/15964384-get-data-from-external-database-not-working-ms-q > > <https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/15964384-get-data-from-external-database-not-working-ms-q> > > -Tim > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html <http://lists.4d.com/faqnug.html> > Archive: http://lists.4d.com/archives.html > <http://lists.4d.com/archives.html> > Options: http://lists.4d.com/mailman/options/4d_tech > <http://lists.4d.com/mailman/options/4d_tech> > Unsub: mailto:[email protected] > <mailto:[email protected]> > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
