my csv contain mix datatype f.ex. in cell E8 data format is date, and other data in this E column are string.
i use this connetion string in classic asp ,VB Script and back end SQl server

ChekCnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Path1 & ";Extended Properties=""text;HDR=YES;IMEX=1;FMT=Delimited"""
Set rs1 = ChekCnn.Execute("SELECT \* FROM myCSV.csv")

problem here is when if at cell E8 is there date then other cell which contain string data will not read and show as blank and if at Cell E8 is blank then it read each cell data of column E.