![odbc excel driver login failed external table odbc excel driver login failed external table](https://36chambers.files.wordpress.com/2020/02/access_odbc_drivers.png)
whilst I now have 64bit windows and excel, the spreadsheets were created when I had 32bit excel, so the properties have been updated and all is well.
![odbc excel driver login failed external table odbc excel driver login failed external table](http://i.stack.imgur.com/QJyB0.jpg)
Attempts in Power BI Gateway, windows authentication is used on power bi desktop to. Re: microsoftODBC Driver Manager Data source name not found and no default driver spec Hi CK You were right. Excel 2007 ODBC Driver"Ĩ) In the drop down box next to "Database Version:" verify that "Excel 12.0" is selected for Excel 2007 (.xlsx) files, or "Excel 97-2000" is selected for Excel 2003 (.xls) files, etc. It is returning an error complaining about locating the ODBC driver. "Excel 2007"ħ) In the box next to "Description:" type in a description. To Configure an ODBC Excel Driver do the following:ġ) Open the Control Panel -> Administrative Tools -> Data Sources (ODBC)Ģ) A Windows Dialog Box named "ODBC Data Source Administrator" will appearģ) Click on the User DSN tab, then click AddĤ) Scroll down until you see "Microsoft Excel Driver (*.xls, *xlsx, *xlsm, *xlsb)", Select it, Click "Finish"ĥ) A Windows Dialog Box named "ODBC Microsoft Excel Setup" will appearĦ) In the box next to "Data Source Name:" type in a name for the Data Source, i.e.
![odbc excel driver login failed external table odbc excel driver login failed external table](https://communities.bentley.com/cfs-file/__key/communityserver-wikis-components-files/00-00-00-00-43/6378.6.jpg)
NOTE: The error in this instance "SQLDriverConnect failed : External table is not in the expected format.", was caused by selecting an Excel 2003 ODBC Driver to open up an Excel 2007 file. Excel 2003 or Excel 2007) you are trying to open. Make sure you are using the Correct ODBC driver for the version of excel (i.e. NOTE: if you have Excel 2003 installed your value in the "Files of Type" dropdown menu will be "Excel(*.xls)"Ģ) Browse your system and select the Excel file you wish to open. To open up your Excel file directly in Statistics, launch Statistics and do the following from the menus in the Statistics Data Editor Window:ġ) File>Open>Data and select "Excel(*.xls, *.xlsx, *.xlsm)" in the 'Files of type' dropdown menu