I was in a hurry and didnt pay much attention to formatting.

I found a temporary work around (I think it might be permanent solution).
earlier I converted the excel file to csv manually by copying them to a text file and seperating them by ','

This time i converted the excel to CSV by saving it as CSV and my script worked fine.

--------------------------------------
but I tried to build a script which inserts the values into the table reading the text file line by line.( I have pasted it below)

---------------------------------------------------
text.txt
----------------------------------------------------
1/1/2009,12/30/2008
2/1/2009,1/31/2009
3/1/2009,2/28/2009

TABLE :
----------------------------------------------------
has 2 columns { A (datetime),B(datetime)}

My Script
---------------------------------------------------
while read line
echo ${line}

a= `awk -F "," '{print$1} ${line}`( i kow i cant specify ${line} here- just wanted to tell you that i want to read line by line)
b= `awk -F "," '{print$2} ${line}`

isql -U${USER_NAME} -D${DB} -b -w400 -A8000<<!
${PASSWORD}
insert into TABLE values(${a},${b})
go
!
done < text.txt


i know that i have done a basic mistake specifying ${line} where AWK tries to find a file named by ${line} and scolds me.

I want your help to build something that reads the text file line by line and inserts those values into table after every line until end of file


Thanks in advance.