Unreadable result when loading CSV into datatable
Microsoft.Jet.OLEDB.4.0 provider doesn't support UTF-8 text files with BOM.
Let's change the way that we save CSV with extractor.
Instead of using
SaveCSVToFile(), use the following:
using (Stream fileStream = File.OpenWrite(outputFileName)) csvExtractor.SaveCSVToStream(fileStream);
This construction will save UTF-8 file without BOM and solve the issue.