Some date fields are wrongly read as null from excel spreadsheet using Microsoft.Jet.OLEDB.4.0

       Dim ConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""

        Dim sqlStatement As String = "SELECT * FROM [" + ExcelFileName + "]"
        Dim con As New OleDbConnection
        Try


            dap = New OleDbDataAdapter( _
                      sqlStatement, _
                        con)
            dst = New DataSet()
            dap.Fill(dst)
Some date fileds are filled as null even though they have valid dates,  Is it something to do with date format vs. numeric format?

How to fix it?
akulasAsked:
Who is Participating?
 
PakaConnect With a Mentor Commented:
To troubleshoot this one, you'll need to comment out your exception handing to see how the nulls are being populated.  Do you have more code to view?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.