Mixed Data in Datagridview from Excel

[kareninstructor]

Perhaps the following might work. Not sure as I don't have a sheet with that much data here at home.

Dim Builder As New OleDbConnectionStringBuilder With
    {
        .DataSource = "Your File Name",
        .Provider = "Microsoft.ACE.OLEDB.12.0"
    }
Builder.Add("Mode", "Read")
Builder.Add("Extended Properties", "Excel 12.0; HDR=Yes;TypeGuessRows=0;")