You can import only one worksheet at a time.  The most straightforward way to
to this would be to create two tables in Access.  One would be the permanent
table that will hold all the data from the 118 worksheets, and one temporary
table that would be used as an intermediate to receive the data from the
worksheets.  You will also need to create an append query that will move data
from the temporary table to the permanent table.

The do the following:
1. Delete all the data in the temp table
2. Import a worksheet into the temp table
3. Run the append query to move the data into the premanent table.

Repeat this process for all the worksheets.