Microsoft Access OLE DB

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.

For further reading:

• Overview
• HTML specifica

Microsoft Access

SELECT *
  FROM tblTable 
    IN 'c:\data.mdb'

Microsoft Excel

Worksheet

SELECT *
  FROM [Worksheet$] 
    IN 'c:\data.xls'[EXCEL 8.0;];

Named Range

SELECT *
  FROM [NamedRange] 
    IN 'c:\data.xls'[EXCEL 8.0;];

Reference

SELECT *
  FROM [Worksheet$A1:B2] 
    IN 'c:\data.xls'[EXCEL 8.0;];

Optional Parameters

• HDR = yes|no
• IMEX = 0|1

Text file

SELECT *
  FROM data.csv 
    IN 'c:\'[TEXT;];

Optional Parameters

• HDR = yes|no