This guide will show you how to import your contacts from the Address Book in Microsoft Outlook into Microsoft Access.
The database management software Microsoft Access provides users with the ability to import their contacts from the Address Book in Microsoft Outlook, so that you can manage the data much more easily. Here’s how –
- Launch Microsoft Access and navigate to the External Data tab on the ribbon, then click the More menu and select Outlook Folder
- Choose where and how to store the data by selecting one of the available options. Click OK to continue.
- Now select your Outlook Address Book and then click the Next button.
- If you get a message about a “potential security concern” you can safely ignore it by clicking Open
- Access will now start importing your contacts from the Microsoft Outlook Address book. You can select/un-select various options here such as the field names which you want to give to the contacts e.g. address, cell number, office number etc. Also, you can choose which fields to import from Outlook or not.
- Choose primary key by selecting the option Let Access add primary key
- Specify name for the imported table. Click Finish to review the contacts table that’s about to be created in Access.
- You may be prompted to save the steps you just chose, which probably isn’t necessary – so just leave the Save import steps box unchecked and then click the Close button.
- Access will now display the contacts imported from Outlook in the form of a table with data entries. You can perform the standard functions the same as you would any other Access table.
- In order to delete a column, right-click it and select Delete Field
- That’s it – you can now arrange contacts more efficiently with their corresponding primary keys and attributes in Access and export them back to Outlook.
1 thought on “How to Import Microsoft Outlook Contacts Into Microsoft Access”
very helpful! thank you.