In this article I have described you how to move your data from Excel to Access and convert your data to relational tables.  Some time we have required moving data from excel sheet to access table because Access is best for capturing, storing, querying, and sharing data, and Excel is best for calculating, analyzing, and visualizing data. So both are play different roll with same data.

Step 1: First create one excel sheet with some data as below image

Figure 1:

Step 2:  Create new database in Access as below image

Figure 2:

Step 3: Click the External Data tab at the top of the Access screen and click the Excel button to begin the Excel import process as below image

Figure 3:

Figure 4:

Note: In this article, we're interested in converting an existing Excel spreadsheet to a new Access database, so we'll choose "Import the source data into a new table in the current database."

Step 5: In this step, you select sheet name where you have inserted data. See below image

Figure 5:

Step 6: Select row for making table’s column name. See below image

Figure 6:

Step 7: Select Index and that data type as below image

Figure 7:

Step 8: Select primary key for table as below image

Figure 8:

Step 9: Provide table name and click on Finish button as below image

Figure 9:

Step 10: Check your data into access table as below

Figure 10:

I hope you enjoy this article and this is very helpful for you.