On the bottom half of the screen, you’re presented with import destination options. In this tutorial, 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 databaseOther options on this screen allow you to:
Link your database to an Excel sheet so that changes in the source sheet are reflected in the database.Import data into an existing database table.
Once you’ve selected the correct file and option, select OK to continue. Select Next to continue. Keep in mind that indexes create a lot of overhead for your database and will increase the amount of disk space used. For this reason, you want to keep indexed columns to a minimum. In our database, we’ll most often be searching on the Last Name of our contacts, so let’s create an index on this field. We might have friends with the same last name, so we do want to allow duplicates here. Ensure that the Last Name column is selected in the bottom portion of the windows and then select Yes (Duplicates OK) from the Indexed pull-down menu. Select Next to continue. You’ll then be returned to the main database screen where you can view your data by simply double-clicking on the table name in the left panel. Congratulations, you’ve successfully imported your data from Excel into Access!
