Microsoft Office Access does not support linking to an Access database or Microsoft Office Excel workbook saved in a format that is a later version than the current database format

This message appears if you try to link to an Excel file in Office 07 format (xlsx, xlsm), while your Access database is Office 03 or earlier format: mdb.

The only way to remedy this is to have your Import database in accdb format.

Importing Excel files