Before you proceed, we recommend that you decide which Outlook folder you want to import the contacts into. In the next procedure, you import the text file into Outlook. On the next page of the wizard, click Finish.Ĭlick Close without saving the export steps, and then close Access. On the next page of the wizard, select the Tab delimiter, and then select the Include Field Names on First Row check box. In the Export Text Wizard dialog box, ensure that Delimited is selected, and then click Next. Do not select any of the check boxes under Specify export options. You can click OK to accept the default values, or you can click Browse to select a different file location, and then click OK. In the Export - Text File dialog box, make a note of the file name and location suggested by Access. You can also launch the Export - Text File wizard by highlighting the table or query in the Navigation Pane and then on the External Data tab, in the Export group, click Text File.Īccess opens the Export - Text File dialog box. In the Access Navigation Pane, right-click the table or query that contains the contact information you want to export, point to Export, and then click Text File.
Step 1: Export Access contact information as a text file Fortunately, it is easy to export an Access table or query as a text file, and then import that file into Outlook.įor more information about the reverse procedure (importing contacts from Outlook into Access), see the article Import or link to contacts from an Outlook address book.
However, Access cannot directly export data to the Outlook file format, nor can Outlook directly import a table from an Access database. As a result, you might find yourself wanting to export contact data from Access to Outlook. 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)
