FMT=TabDelimited does not work.

unable to fetch data that is tab delimited from text file using OleDbConnection string as below
using (OleDbConnection con =
new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + @";Extended Properties='text;HDR=YES;FMT=TabDelimited';"))
Even when I have provided FMT=TabDelimited the data fetched is CSVDelimited ie delimited by comma.

1 answer

This is because of two different types of data present in the column. So dataset loads the first type of all values. That means if you had put the alphanumeric values first and then the numeric rows, so it would have loaded only alphanumeric values. Because alphanumeric values treated as a type of text.

As a resolution you can select the entire column in the excel file and set its Type to Text. Save it and the reload it. This must solve your problem as once i solved it this way.

Hope that helps. Else, let me know.