How to import data from csv files to SQLite database using C#?

I'm trying to import some csv files into my sqlite database.

I tried using this CP example, but stuck with the exception

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I tried installing the ODBC driver for SQL server, but with no success. The exception is not resolved.

Is there anything that I miss? Or can I follow a different method for this?