Microsoft provides a ODBC driver for CSV/TXT files so that they can be accessed/manipulated from applications using ODBC. The same can be accessed in the Java world using the JDBC type 1 driver, which essentially is a JDBC-ODBC Bridge. There is a detailed tutorial here:
However there is a bug with Microsoft ODBC Text Setup utility. The Text driver creates a file called System.ini which stores the column names with the corresponding datatype and length, header details etc. But the utility (atleast the one provided with Windows XP) doesnt write the datatype and length to the file. This however can be manually changed and System.ini is usually present in the directory in which you specify the CSV file.
For the example in the tutorial the change for System.ini will be:
Col1=STATE Text Width 255
Col2=STATEBIRD Text Width 255