Difference between revisions of "Microsoft Access OLE DB"
Jump to navigation
Jump to search
(Text) |
|||
| Line 25: | Line 25: | ||
* [[Microsoft Access OLE DB — Microsoft Access|Microsoft Access]] | * [[Microsoft Access OLE DB — Microsoft Access|Microsoft Access]] | ||
* [[Microsoft Access OLE DB — Microsoft Excel|Microsoft Excel]] | * [[Microsoft Access OLE DB — Microsoft Excel|Microsoft Excel]] | ||
| − | * [[Microsoft Access OLE DB — | + | * [[Microsoft Access OLE DB — Text (CSV, TSV, TXT)|CSV, TSV, TXT]] |
* [[Microsoft Access OLE DB — Hypertext Marckup Language (HTML)|HTML]] | * [[Microsoft Access OLE DB — Hypertext Marckup Language (HTML)|HTML]] | ||
* [[Microsoft Access OLE DB — Microsoft Outlook|Microsoft Outlook]] | * [[Microsoft Access OLE DB — Microsoft Outlook|Microsoft Outlook]] | ||
Revision as of 15:59, 8 November 2016
General
It is possible to access some resources without writing any line of code. All you need is to write a query which makes use of ISAM OLEDB (see the Overview provided by Microsoft).
The ISAM OLEDB type must be put in square brackets and and with a semicolon like in this example for an Microsoft Excel workbook:
SELECT *
FROM [...]
IN '...'[EXCEL 8.0;];
If you need to specify optional parameters they have to be appended to the ISAM type:
SELECT *
FROM [...]
IN '...'[EXCEL 8.0;HDR=yes;IMEX=0;];
ODBC
…
…