Difference between revisions of "Microsoft Access OLE DB"
Jump to navigation
Jump to search
| (16 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== General == | == 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. | + | 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 | ||
| + | [http://msdn.microsoft.com/en-us/library/aa164914(office.10).aspx 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: | |
| − | |||
| − | + | <syntaxhighlight lang="sql" highlight="3"> | |
| − | |||
| − | |||
| − | <syntaxhighlight lang= | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
SELECT * | SELECT * | ||
| − | FROM [ | + | FROM [...] |
| − | IN ' | + | IN '...'[EXCEL 8.0;]; |
</syntaxhighlight> | </syntaxhighlight> | ||
| − | + | If you need to specify optional parameters they have to be appended to the | |
| − | + | ISAM type: | |
| − | |||
| − | + | <syntaxhighlight lang="sql" highlight="3"> | |
| − | <syntaxhighlight lang= | ||
SELECT * | SELECT * | ||
| − | FROM | + | FROM [...] |
| − | IN ' | + | IN '...'[EXCEL 8.0;HDR=yes;IMEX=0;]; |
</syntaxhighlight> | </syntaxhighlight> | ||
| − | + | * [[Microsoft Access OLE DB — Microsoft Access|Microsoft Access]] | |
| − | * | + | * [[Microsoft Access OLE DB — Microsoft Excel|Microsoft Excel]] |
| − | + | * [[Microsoft Access OLE DB — Text (CSV, TSV, TXT)|CSV, TSV, TXT]] | |
| − | + | * [[Microsoft Access OLE DB — ODBC|ODBC]] | |
| − | + | * [[Microsoft Access OLE DB — Hypertext Marckup Language (HTML)|HTML]] | |
| − | + | * [[Microsoft Access OLE DB — Microsoft Outlook|Microsoft Outlook]] | |
| − | |||
| − | [ | ||
| − | |||
| − | + | * [[Microsoft Access OLE DB — Microsoft SharePoint|Microsoft SharePoint]] | |
| − | |||
| − | * | ||
| − | |||
| − | + | [[Category:Microsoft Access]] | |
| − | + | [[Category:SQL]] | |
| − | |||
| − | |||
Latest revision as of 11:04, 15 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;];