The free trial mode of the driver works the same as the full version except that only a handful of records is returned. Installing the free trial installs the full working version of the ODBC Manager application. I know of only one driver that works, the ActualTech driver. It works the same as the full version, but returns only the first 5 or so records of your query. Installing the driver also installs the new 64-bit ODBC manager application to your Applications > Utilities folder. You will need to install theĪctualTech Access driver. Now, only people who want these connections and are willing to
ODBC drivers and the ODBC manager application were casualties of making Mac OS free. On the Mac side, the infrastructure required to preform ODBC connections is no longer included with Mac OS. The ability to perform SQL queries is already built into Excel.
Knowing Structured Query Language (SQL) at least at a beginner level is essential. Just so you know, you can automate your query process with VBA, AppleScript, Objective-C, or Javascript, but it is certainly not required or necessary to use any of these languages.
Knowing Visual Basic for Applications is not required. The first time through will be the most difficult, but once you see how all the pieces fit together, you will be able to run your queries with little to no difficulty.
Yes, it is easy once you know how to do it.
In Excel for Mac you can use Microsoft Query to make a PivotTable using multiple worksheets from an Excel workbook as your data source. PowerQuery uses the Data Model, a feature that exists but is not exposed in Excel for Mac. PowerQuery uses queries as its name implies.