Microsoft Access OLE DB — Text (CSV, TSV, TXT)

Text file

When dealing with text files the folder of the file is interpreted as database and the text file itself as table source.

It is possible—and highly recommended—to specify the content of the text file by creating a schema.ini with the specification details.

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

Optional Parameters

HDR

The header parameter specifies, whether the first row should be interpreted as column headers.

Possible values: HDR=yes, HDR=no