load data infile

how can i use load data infile to do the following

data file has 5 fields:
a,b,c,,e

table has 4 columns
table colums = (a,b,c,e)

load data infile 'file.txt' into table 'this_table' (a,b,c,,e)

will not work ? is it posable to make it work ?
I want to skip the empty column in the text file.
On a Linux box....

Note: bcp is a microsoft program and will not run on Linux.

You can use bcp to import the data and specify to skip a column by using a format file. See http://msdn.microsoft.com/library/d...cp_bcp_61et.asp for the bcp utiltity. At the bottom of the page is a link that tells you how to make/use format files. Hope this helps