Move data from Excel to Access
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
Step 2: Create new database in Access as below image
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
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
Step 6: Select row for making table’s column name. See below image
Step 7: Select Index and that data type as below image
Step 8: Select primary key for table as below image
Step 9: Provide table name and click on Finish button as below image
Step 10: Check your data into access table as below
I hope you enjoy this article and this is very helpful for you.