Microsoft Access OLE DB — Hypertext Marckup Language (HTML)

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

HTML

While this works theoretically in general, there are many problems with selecting data from web sites. These HTML specifica make it impracticable to work with HTML tables this way.


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.