Yes, it is possible to import data from csv files using ODBC.
Syntax
ODBC: "Driver=Microsoft Access Text Driver (*.txt, *.csv); Dbq=<Complete Path without File Name>; Extensions=asc,csv,tab,txt;"
Example
[Collection : Ledger SRCCollection]
ODBC : "Driver=Microsoft Access Text Driver (.txt,.csv);Dbq=C:\CSVImport\;Extensions=asc,csv,tab,txt;"
SQL : "Select * from SampleData.csv"