I am trying to bulk insert information from a file data.txt and in this data.txt file I have two types of rows which I can insert data from one being:

name * description * date * date * image * image * image

and the second being

name * description * number of days * image * image * image

my table in which I am trying to insert this into has columns for all of these:

name * description * date * date * number of days * image * image * image

but I do not know how to make it tell when it needs to insert into the number of days column or in the date columns. Also if this might help the description helps you know what will follow in the file, either dates or number of days.

I tried the normal bulk insert but just as expected I got errors telling me that the data is not inserting right