villehilt.blogg.se

The location of the import/link text wizard differs slightly depending upon your version of Access. Open the Access database into which you want to import the data. Step 2: Import the contact data into Access Outlook exports the contents of the selected folder to a text file. On the next page of the wizard, click Finish. If you want to save the file to a different location, click Browse, and then browse to the folder in which you want to save the file. Note: By default, Outlook saves the file to your default documents folder. In the Outlook Options dialog box, click Advanced and then under the Export section, click Export. If you're using Outlook 2010, click File > Options. If you're using the subscription version of Outlook, Outlook 2019, Outlook 2016 or Outlook 2013, on the File tab click Open & Export and then click Import/Export. Choose the steps that match your Outlook version: The location of the export wizard differs slightly depending upon your version of Outlook. Step 1: Export the Outlook contacts to a text file

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. Access and Outlook are both excellent programs for managing your personal and business contacts.