csv column contain mix datatype connot read all cell data using oledb provider

[nilesh tayde]

my csv contain had different 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 and back end SQl server

ChekCnn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" & Path1 & ";Extended Properties=""te xt;HDR=YES;IMEX =1;FMT=Delimite d"""
Set rs1 = ChekCnn.Execute ("SELECT * FROM ["& x.name &"]")

[jhardman]

Ideally (best practices) they should all be the same data type in a column, so either store the date as a string so that everything in that column are consistent, or add another column.

Jared