Select 'Use connection string' and hit 'Build…'.Select the 'Microsoft ODBC Data Source' option and click 'OK'. In the Connection Properties dialog, click 'Change…'.In Tabular Editor, right-click on the model, choose 'Import tables…', click 'Next'.Confirm the installation by looking in the ODBC Data Sources (32-bit) configuration (Windows start button, search for 'ODBC', platform should say '32/64 bit', as in the screenshot below):Īfter making sure you have the 32-bit ODBC Excel driver installed, as described above, adding a table from an Excel file with Tabular Editor 2.x requires the following steps:.Inside, you will find the aceredist.msi file, which should be executed through the command line with the /passive switch:.Unzip the AccessDatabaseEngine.exe file.Download the 32-bit version of the driver from here:.However, it is possible to install the 32 bit Excel ODBC driver next to the 64-bit Office, by using this workaround: Unfortunately, Tabular Editor 2.x can't use the 64-bit driver, and simply downloading and attempting to install the 32-bit driver, will give you an error if you already have a 64-bit version of Office installed. Tabular Editor 2.x is a 32 bit application, and most people usually have the 64 bit version of Office installed (which includes a 64-bit Excel ODBC driver).

If you need to add Excel worksheets as tables to your tabular model, this is possible with Tabular Editor 2.x and the Excel ODBC driver.

Excel odbc driver download