for jb_lbm

in case you need to ignore the last few rows, you can import the entire file using DTS into a temporary table and then using a query, move only...

in DTS, instead of using the "First Row has column Names" which will skip only the first row -- If you have a text file source, then you can also...