Don't have Excel open when Importing Excel files!
If in Access you have a linked table to an Excel file, Access does not like it when you have Excel open. The Excel Data Link Properties dialog persistently pops up which may even finally result in a crash.
If this dialog occurs, best is to keep pressing [Cancel]
|Importing Excel files|