usually once you click New Query option, please note under the ODBC Data sources section the Excel option will be displayed. Which you can click to select Excel option. If Excel is not getting displayed please click Add ODBC Data source and enable ODBC drivers for excel. Then Excel option will be displayed. which you can use to import.
V nice n informative
How to choose excel in new query
usually once you click New Query option, please note under the ODBC Data sources section the Excel option will be displayed. Which you can click to select Excel option. If Excel is not getting displayed please click Add ODBC Data source and enable ODBC drivers for excel. Then Excel option will be displayed. which you can use to import.