Import Excel into Access Macro

[PanzerAttack]

How can I automate importing some files from Excel into Access.

The TransferSpreadsheet Macro Action doesn't allow me to select the range for some reason.

In Tables New - Import Table works perfectly

How can I automate this way of importing Tables to import 200 tables directly from Excel.

I found this

http://www.databasedev.co.uk/text-import-macro.html

which looks ideal but I can't see a way to save it when I Import Excel (no Advanced tab).

Any ideas? I'm sure I'm missing something obvious.

 

[Joe4]

The TransferSpreadsheet Macro Action doesn't allow me to select the range for some reason.

I usually use named ranges, and this seems to work quite well.