|3. In the new action window click the top dropdown and select 'Transfer Excel data to Access' under 'Access operations':|
|4. Enter the Excel workbook name, the sheet name and the range, the Access database path and finally the target table name.
Make sure that headers are not inlcuded in the Excel range. Named ranges are also supported.