Text Files as Data Sources


The name of the driver will usually be:
Microsoft Text Driver (*.txt; *.csv)

Please note that the file extension information at the end is actually part of the driver name.

A directory with one or more .csv files is specified in the DBQ. Each .csv file is conceptually a table.

Although using a DSN is recommended, a typical configuration without one would be:

<query> <driver>Microsoft Text Driver (*.txt; *.csv)</driver> <dbq>C:\MyFiles</dbq> <sql>Select * From MyTable.csv Order By X</sql> <query>