Select the desired worksheet(s) or named range(s) from the selected spreadsheet. Click [Next].
Note: Excel worksheets are assumed to always contain a first row containing column headings. If your worksheet doesn’t contain a heading row, add a heading row before importing.
To select columns and to edit the Where and Order clauses, de-select Define Multiple Tables, select Edit Query and click [Next]. Otherwise, clicking [Next] will advance directly to the Final panel.
To create a custom SQL Query, check the Create SELECT checkbox and click [Next]. Enter/paste a valid SQL Select statement in the SQL SELECT dialog that appears and then click [OK] to advance to the Final panel.
If more than one worksheet or named range is selected, and Define Multiple Tables is de-selected, you will need to specify the key fields to be used to join the worksheets. Click [OK].
The Select Tables dialog now displays the specified join criteria. Click [Next].
To define multiple worksheets independently at one time, select Define Multiple Tables.
After selecting the desired worksheets or named ranges, clicking [Next] will advance you directly to the Final panel.
Each table layout will be named based on the worksheet name and the selected worksheets or named ranges can either be flattened or read directly.