Link data from
Microsoft Outlook into a Microsoft Access Database
Provided by: Dave Juth, Senior Systems Architect
Did you know you can link data from Microsoft Outlook into
an Access database? To do this, follow these steps:
-
Create a new database called Outlook.mdb.
-
Select File | Get External Data | Link Tables.
-
In the Files of Type dropdown, select Outlook().
-
In the Link Exchange/Outlook Wizard dialog box, expand the Address Book,
Mailbox, or Public Folders and select the data to link into Microsoft Access as a
table. For example, to link Contacts data, expand your mailbox and
select the Contacts node. Click Next, name the table ‘Contacts,” and
click Finish.
-
When the Link/Exchange Wizard prompts you with the finished dialog,
click the OK button and you will see a linked table in your database to
your Microsoft Outlook data.
Return to the tips page
|
