First off I am new to VB.NET, I took one course in college, but it is not helping me here... We did simple programs (1+1=2) type of things....


I am trying to create an application that will read from a text tab delimited file and input certain data into an excel spreadsheet template.


The text file has 6 columns (these titles of the columns do not appear in the text file)
ID REF_ID RESPONSE LOCATION SURVEY_DATE SUBMIT_DATE
Here is an example of the data......

32993 6 1 AZ: Phoenix Retail Activation Center (RAC) 02/02/04 02/02/04

I need code to basically say....

If REF_ID = 2 and location = "HERE" and SURVEY_DATE is = to tbstart.txt then PLACE RESPONSE in excel document. Cells (14, 2)
If REF_ID = 6 and location = "HERE" and SURVEY_DATE is = to tbstart.txt then PLACE RESPONSE in excel document. Cells (3, 2)

And so on and so on....

I have tried several different things and nothing is working.