I have coulumn name called exp_date which is in dd/mmy/yyyy format in my csv file and I need to update this column with the format mm/dd/yyyy. I could connect to my CSV file using OLEDB provider and display the data using recordset , now how do I update the column name with values. can i use a normal Sql update in my asp page?

thanks,
Madhuri

Use FileSytemObject