Microsoft Access OLE DB — Microsoft Outlook

From database24
Revision as of 15:58, 8 November 2016 by Dec (talk | contribs) (Initial)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Microsoft Exchange

It is possible to query Exchange / Outlook folders and address books as follows:

SELECT *
  FROM Inbox 
    IN 'c:\temp\'[Exchange 4.0;MAPILEVEL=Account - Paul Stevens|;TABLETYPE=0;];

where Account - Paul Stevens has to be replaced by the exact name of the Inbox followed by the pipe (|). This works for Contacts, Calendar and other folders too.