> On 10 Oct. 2015, at 1:42 am, Keisuke Miyako <[email protected] > <mailto:[email protected]>> wrote: > > I don't have Office 2016, but is it not a 64 bit application? > > in that case, then I guess you need to use the 64 bit version of ODBC Driver, > which has been available since 14R2. > > http://doc.4d.com/4Dv15/4D/15/4D-ODBC-Driver.100-2400401.ja.html > <http://doc.4d.com/4Dv15/4D/15/4D-ODBC-Driver.100-2400401.ja.html> > >> 2015/10/09 9:31、James Brown <[email protected]> のメール： >> Downloaded that, but it is from 2002 and is a PowerPC app, so won’t work on >> modern versions of OS X. >> In recent MS Excel, I’m using gate Get External Data/From Database which >> opens iODBC Data Source Chooser inside Excel. >
Trying this again, with Office 2016. Ie Microsoft Excel for Mac version 15.25.1 (160826). This is the new 64-bit one. Does that make a difference? Has anyone had any luck getting Excel to connect TO 4D via ODBC? All the info and the driver on the 4D web site seem to be about getting info FROM 4D using ODBC. I’m sure I’ve set something up incorrect in iODBC Data Source Administrator, as I keep getting: [iODBC][Driver Manager]Specified driver could not be loaded When I try to use the connection in Excel. Anyone have any working odbc.ini and odbcinst.ini files from /Library/ODBC/ that they are willing to share? Any other tips? Running 4D 15.1 on Mac Server. Thanks, James. ********************************************************************** 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] **********************************************************************
