A family of Microsoft relational database management systems designed for ease of use.
- Create a new blank db
- External Data
- Import & Link -> Excel
- Browse and select .xlsx file
- Select Import the source data into a new table in the current database.
- Click OK
- Error comes up:
Microsoft Access can't find the wizard. This wizard has not been installed, or there is an incorrect setting in the Windows Registry, or this wizard has been disabled.
To reenable this wizard, click the File tab, and click Access Options. Click Add-Ins, and then in the Manage list, click Disabled Items, and then click Go. Rerun Microsoft Access or Microsoft Office Setup program to reinstall the wizards. If the missing wizard is not a Microsoft Access wizard, reinstall it using the Add-in Manager.
I have check the disabled Add-Ins and there are none.