As long as the CSV file is always in the same format - that is - always the same columns and in the same location, you can probably set up an ODBC entry on the comptuer, then connect to the ODBC entry with the standard SQL generators.
this link has some info in how to set up the ODBC entry (it's got a lot of other stuff too, but it's the best one I've found):
http://www.c-sharpcorner.com/UploadFile/mahesh/AccessTextDb12052005071306AM/AccessTextDb.aspx
This should allow you to query the CSV, and let he ODBC driver on the PC/Server do all the work.
Rob