|
|
Link
data from Microsoft Outlook into an 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 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 |