---
title: "Move data from Excel to Access"  
description: "In this article I have described you how to move your data from Excel to Access and convert your data to relational tables."  
author: "AVADHESH PATEL"  
published: 2013-04-04  
updated: 2019-09-07  
canonical: https://www.mindstick.com/articles/1213/move-data-from-excel-to-access  
category: "ms access"  
tags: ["ms access"]  
reading_time: 2 minutes  

---

# 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](https://www.mindstick.com/blog/10885/equality-relational-and-conditional-operators) tables. Some time we have required moving data from [excel sheet](https://www.mindstick.com/forum/23040/to-import-excel-sheet-into-sql-database) to access [table because](https://www.mindstick.com/forum/159042/cannot-truncate-table-because-it-is-being-referenced-by-a-foreign-key-constraint-why) 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](https://www.mindstick.com/mindstickarticle/c71e8031-a4ab-4149-8b5e-5326f1cd41e2/images/dec0b2fa-6289-4618-a87e-eef2e4a12935.png)

Step 2: Create new database in Access as below image

##### Figure 2:

![Move data from Excel to Access](https://www.mindstick.com/mindstickarticle/c71e8031-a4ab-4149-8b5e-5326f1cd41e2/images/541d2d2b-789f-4232-b597-65ae839aaeef.png)

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](https://www.mindstick.com/mindstickarticle/c71e8031-a4ab-4149-8b5e-5326f1cd41e2/images/9aebb1bc-bf87-4124-83f8-1df95c9b3df9.png)

##### Figure 4:

![Move data from Excel to Access](https://www.mindstick.com/mindstickarticle/c71e8031-a4ab-4149-8b5e-5326f1cd41e2/images/458700e2-ccd0-46f6-bc8a-b5ee1cddf0ca.png)

Note: In this article, we're [interested in converting](https://answers.mindstick.com/qa/41080/why-were-the-puritans-at-first-so-interested-in-converting-the-native-americans) an existing Excel [spreadsheet](https://answers.mindstick.com/qa/31730/explain-spreadsheet-and-its-basics) to a new [Access database](https://www.mindstick.com/forum/385/access-database-datatype-problem), 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](https://www.mindstick.com/mindstickarticle/c71e8031-a4ab-4149-8b5e-5326f1cd41e2/images/183f4571-0463-4b27-a546-a43265b0fe69.png)

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

##### Figure 6:

![Move data from Excel to Access](https://www.mindstick.com/mindstickarticle/c71e8031-a4ab-4149-8b5e-5326f1cd41e2/images/c2cfc993-961d-4396-a164-114516f40e11.png)

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

##### Figure 7:

![Move data from Excel to Access](https://www.mindstick.com/mindstickarticle/c71e8031-a4ab-4149-8b5e-5326f1cd41e2/images/c2ec745b-f73e-41ad-bd94-f8738c5ede9d.png)

Step 8: Select primary key for table as below image

##### Figure 8:

![Move data from Excel to Access](https://www.mindstick.com/mindstickarticle/c71e8031-a4ab-4149-8b5e-5326f1cd41e2/images/0ffb7ad7-8d5e-4069-a854-6fb270e58f4d.png)

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

##### Figure 9:

![Move data from Excel to Access](https://www.mindstick.com/mindstickarticle/c71e8031-a4ab-4149-8b5e-5326f1cd41e2/images/7846cc19-dc14-4515-b71c-2406db2f7cc1.png)

Step 10: Check your data into access table as below

##### Figure 10:

![Move data from Excel to Access](https://www.mindstick.com/mindstickarticle/c71e8031-a4ab-4149-8b5e-5326f1cd41e2/images/a3814527-938e-4fff-97c1-913c8415f896.png)

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

---

Original Source: https://www.mindstick.com/articles/1213/move-data-from-excel-to-access

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.