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: