Today installed monetdb for first time and wanted to play with some of the features but stuck with loading the file. Excuse me if this looks too basic. There is a 3GB csv file (1M rows and 400 columns). I am trying load in monetdb on my windows 7 machine. I first created a table mostly data is numeric exect for few that are metadata strings. How do i load this file without removing the header. The error says column_name not of type integer since the column_name is the actual header string but the values are integers. I can remove the header manually before loading but if i plan to scale then it is not a good option. Is there a way to say load "n" records from file starting at 'x' to 'y'? or ignore first line. COPY 1000000 RECORDS into mytable from 'C:\data.csv' delimiters ',', '\n'; Thanks. -- View this message in context: http://old.nabble.com/load-CSV-without-header-row-tp33096188p33096188.html Sent from the monetdb-users mailing list archive at Nabble.com.