The attachment has a routine which will take all the xls files (from the folder you select) and will import ALL those xls files (in that folder) into the mdb file automatically.

It's all menu driven so you only need to select the folder that has all the xls files and then click the import button.

Note: if you have long excel filenames you're importing, you can use the LEFT (see Importing Module) to truncate the long xls filename into shorter table names. See comments in the module: Importing Module.

(Also Note: you should copy the xls files first to a non-spaced folder but the routine will work with spaces in the folder.)

Also note: you can use this to import other files automatically as well (just change the xls to the file format you wish to import.) You may also need to change the docmd.transferspreadsheet to accommodate your import type.