In this tutorial it is explained how to create MS Access database from excel worksheet. First, we need to create new MS Access database.
We need to give full path and type name of new database.
And then, click “Create”.
Then we must witch to “External Data” tab.
Now, choose “Excel”.
Final step is to choose option “Import the source data into a new table in the current database”.