If you have trouble using the wizard (for example, if the wizard does not import a field that you need), you can try exporting the contacts from Outlook as a text file and then importing that text file into Access. Top of Page Import contacts by using a text file As such, the screenshot above might not match exactly what you see in your application.įollow the instructions on the remaining pages of the wizard.Īfter you complete the wizard, Access imports or links to the contact data that you specified. Note: The look of the Link Exchange/Outlook Wizard differs slightly depending upon your version of Access and Outlook. Select the folder that contains the contacts that you want to import into Access. In the Exchange/Outlook Wizard dialog box, select the folder or address book that contains the contacts that you want, and then click Next.Ģ. In the Get External Data - Outlook Folder dialog box, select the option that you want, and then click OK. If you're using Access 2016, Access 2013, or Access 2010, on the External Data tab, in the Import & Link group, click the More button to drop down a list of options and then click Outlook Folder. If you're using the latest version of the Microsoft 365 subscription version of Access or Access 2019, on the External Data tab, in the Import & Link group, click New Data Source > From Other Sources > Outlook Folder. Choose the steps that match your Access version: The location of the import/link wizard differs slightly depending upon your version of Access. Changes made to the data in Access are reflected in Outlook, and vice versa. By contrast, if you use the link option, Access maintains a link to the Outlook data. Changes made to the data in either program do not affect the data in the other program. If you import the data, Access creates a copy of the Outlook data and puts it in an Access table. You can use the Exchange/Outlook Wizard to import or link to Outlook contact data. Import or link to Outlook contacts by using the Exchange/Outlook Wizard
As a result, you might want to import or link to contact data from Outlook into Access.įor more information about the reverse procedure (exporting contacts from Access to Outlook), see the article Export contacts to an Outlook address book. LessĪccess and Outlook are both excellent programs for managing your personal and business contacts.
Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More.
0 kommentar(er)
