Home > DeveloperSection > Articles > Move data from Excel to Access

Move data from Excel to Access


MS Access MS Access 
Ratings:
0 Comment(s)
 2370  View(s)
Rate this:

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

Figure 1:

Move data from Excel to Access

Step 2:  Create new database in Access as below image

Figure 2:

Move data from Excel to Access

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:

Move data from Excel to Access

Figure 4:

Move data from Excel to Access

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:

Move data from Excel to Access

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

Figure 6:

Move data from Excel to Access

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

Figure 7:

Move data from Excel to Access

Step 8: Select primary key for table as below image

Figure 8:

Move data from Excel to Access

 

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

Figure 9:

Move data from Excel to Access

Step 10: Check your data into access table as below

Figure 10:

Move data from Excel to Access

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


Don't want to miss updates? Please click the below button!

Follow MindStick