Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Help and How-to
Search
Search
 
Icon: Try: (c) Microsoft
2007 Office system - try and buy
Updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Link Outlook contacts to an Access database
 
Applies to
Microsoft Office Outlook® 2003
Microsoft Outlook® 2002
Microsoft Office Access 2003
Microsoft Access 2002

You can quickly copy or link to your Outlook contacts in an Access database, enabling you to work with your Outlook contacts in an Access database. Your Access data is kept up to date with changes to Outlook contacts, and vice versa, if you choose to link contacts to Access.

  1. Open Access and start a new, blank database or open an existing database.
  2. Do one of the following:
    • On the File menu, point to Get External Data, and then click Import.
    • On the File menu, point to Get External Data, and then click Link Tables.

    Note  If you link Outlook data to Access, any items updated in Outlook are automatically updated in Access.

  3. In the Link or Import dialog box, in the Files of Type list, click Outlook.

    If you have more than one Outlook profile, you are prompted for which profile to use.

  4. In the Import Exchange/Outlook Wizard, select the folder or address book that contains the contacts that you want, and then click Next.
    Link Exchange/Outlook Wizard

    Callout 1 Expand the top mailbox folder.

    Callout 2Select the folder that contains the contacts that you want to export.

    When you complete the wizard, the Outlook data is placed into an Access table.

  5. Follow the instructions on your screen.
advertisement