Let us now go through all the fields and then, click Next. Once you are done with the FirstName field, just click on the MiddleInitial field. If you don’t want to import any field, just check the check box which says do not import field. You will now see a dialog box where you can set the data type for each column/field. Let us now check the check box and click Next. In the Preview, you can now see that the first row contains the column headings. Here you will see the preview of your data. Let us select the first option and click Ok. Let us click on that option.īrowse the Excel file from which you want to import data and the then we have different options to store data. In Import & Link group, you will see an option Excel. To import the data in Access, we first need to open the Access database and then go to the External Data tab as in the following screenshot. Let us look at a simple example of data importing from an Excel file. ODBC Databases (For example, SQL Server).Following are the most commonly used data import formats. In the import & Link group, you can see the different kind of options available for data import in Access. To understand what kind of data you can import in the Access data, let us open your database and go to the External Data tab. To save Access as a spreadsheet file, you will need to use the import feature on the External Data tab.ĭifferent Types of Data Access Can Import In Access you can’t use the Save As command in the same way, you can save Access objects as other Access objects, but you cannot save an Access database as a spreadsheet file.
The Save As command is generally used to save a document in another format, so that you can open it in another program.
If you have data in a spreadsheet, a SharePoint list, or some other format, you can import it into an Access database with just a few steps, making it much more, easily available in Access. Normally data is stored in various formats, files, and locations, which makes it hard to get and use it. In this chapter, we will be talking about importing data in Access and what kinds of data you can import using Access.