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.

edit delete
are you sure?
asked Sumit Mogare

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.

edit delete
are you sure?
answered Jack Alex

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions