How to create and import excel data sheet into Access 2025

create and import excel data sheet into access. Today’s post will be enabling you to create your own database in Microsoft Access. We will provide you information about the following.

Table of Contents

How to create and import excel data sheet into Access Database for easy entry

Make an excel database with image links
Make a new database or Import an excel database to access creating tables
Create forms to enter new data and Insert images with data forms
Create a query to get one record of data from the database
Create reports

What is Microsoft Access Database?

The database is the collection of raw data of an organization. Organizations may be any type like government or private, schools, hospitals, data collection centres and offices. The data of the customer is the key to the success of any department. So, every department keeps data of their students and customers etc. for future correspondence, comparing and better planning.

Now, how do they create and keep this data? There are different procedures, software and methods that may be used for this purpose. But we today, will share free software for making your database. Microsoft Access is designed for especially designing databases. We will use this application for developing an access database. Here, we will make the employee’s data with their pictures which will be searchable and printable. A Microsoft access to my work in a series like the one below.

How can we import excel data into the access database?

If you have already designed excel data of the students or employees. We have also made an excel datasheet of the employees working in an organization. This excel sheet data contains information about an employee with their image URL. I put the last column with the image URL and paste the drive URL where pictures are saved. Let’s start to import this excel employee data into the access database. Also want to learn to make PVC cards in CorelDraw, Click here to know.

First of all, your computer should have any version of Microsoft Office. If you already don’t have any version on your computer, click here to install Microsoft Office 2007, 2013,2016 and 2019 full versions.
Now, open the Microsoft Access application by searching in the start search bar.
When the access application opened, click on “Create New Blank Database”.
Now, you have to give a name to this access database. Write the name and then press OK.
Now, select from the access main menu “External Data” and click on it.
Now, click on the excel icons in the “Import” submenu or tab.

A page of source and data links will appear, click on the “Browse” button and select your excel data source file and click open.
In the below checkbox, choose “import data into new table” and click the button ok.
If your excel data have more than one sheet, it will show there all the sheets.
Now, excel sheets column and rows will be shown to you for selection of access table data type.
Choose your headings as the first row by a checkmark on the top and click the Next button.
Now, you have to choose the Data type of every field and headings, after selecting all fields click the next button.
Now, apply a Primary key if you want to apply and select “choose my own key” and select from the dropdown menu from the fields.
After selecting all the above, you have to click the next button to proceed further.
Now, give a name to the access table and press the OK button.
Now, at the last a save process box will appear, you may cancel it.
You have created a table in access by importing it from the excel database. You may create it in excess also and make a table like the above.

How can create forms to enter new data and Insert images with data forms

Forms in Microsoft access are the place where you can enter your data into tables through a good user interface form. This is the form shape that may be used to enter data into the database. You may create a form from the create menu. How to send files into the computer using WiFi without a data cable, learn here.

Click on the “Create” menu and select the form type which you want to insert. Here, we will insert a simple form so, click on the form.
When you click, it will open in the designed view. Replace or set your data values. Arrange these fields in which order you want to enter data into access.
Now, click on the close button, click yes to save forms and then give it a name.
Your form will be created now, click on the form from the left side and enter new data from here.
To insert a picture in the form, click on the image at the menu bar. Draw the circle where you want to show a picture. A brows screen will be opened, you will close it. Now, select the property and select images from the data tab. The URL of your images which you typed in excel will be attached to the database.

How can create a query to get one record of data from the database?

Queries are used to get specific results from the database. If you want to get the science students’ data which have more than 80 marks, you will apply a query to get this data. Queries work like a filter that works according to your demands. You may create it from create the menu and then click on the query button. You may link data to each other to get specific results. If you have more than one table, then using queries you may get more information in one place by combining.

How can create reports in Microsoft Access?

Reports are the final output of your database. By creating reports, you may be able to print your database. You may easily create a report. Click on the create menu and then on reports.