fields blank while filling datatable from csv file

See more:

VB

while filling a datatable from a csv files those columns while contaion mixed datatype e.g. text,numeric in csv file, are coming as blank in datatable

below is the code that i m using

Dim csvFileFolder As String = _PATH
            Dim csvFileName As String = _FILE

            Dim connString As String = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" _
                & csvFileFolder & ";Extended Properties=""Text;HDR=No;FMT=Delimited"""

            Dim conn As New Odbc.OdbcConnection(connString)

            'Open a data adapter, specifying the file name to load
            Dim da As New Odbc.OdbcDataAdapter("SELECT * FROM [" & csvFileName & "]", conn)

            'Then fill a data table, which can be bound to a grid
            Dim dt As New DataTable
            da.Fill(dt)