Difference between revisions of "Microsoft Access OLE DB — Hypertext Marckup Language (HTML)"

From database24
Jump to navigation Jump to search
(Initial)
 
 
Line 1: Line 1:
 
== HTML ==
 
== HTML ==
 
While this works theoretically in general, there are many problems with selecting data from web sites. These [http://ewbi.blogs.com/develops/2006/12/reading_html_ta.html HTML specifica] make it impracticable to work with HTML tables this way.
 
While this works theoretically in general, there are many problems with selecting data from web sites. These [http://ewbi.blogs.com/develops/2006/12/reading_html_ta.html 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:
 
−
 
−
<syntaxhighlight lang="sql" highlight="2-3">
 
−
SELECT *
 
−
  FROM Inbox
 
−
    IN 'c:\temp\'[Exchange 4.0;MAPILEVEL=Account - Paul Stevens|;TABLETYPE=0;];
 
−
</syntaxhighlight>
 
−
 
−
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.
 

Latest revision as of 15:58, 8 November 2016

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.

Retrieved from "http://wiki.database24.net/index.php?title=Microsoft_Access_OLE_DB_—_Hypertext_Marckup_Language_(HTML)&oldid=519"