Change the table range of the Excel file

There are several reasons you may want to change the table range of the Excel file

• When Selecting a table in the Excel file by making it a Linked Table,  The MS Access wizard guesses the range to pick values from. It may have picked a wrong range
• You don't want to pick the whole area selected automatically
• You may have to import multiple worksheets, so you have to switch sheets.

To change the import table range:

1.  press the button [Select range containing the table data]