Encoding issue when reading Excel Sheet created by Microsoft Access 2007/2013

Jul 16, 2014 at 2:49 PM
In Microsoft Access 2007 or 2013 a Table can be exported using the Export Spreadsheet Wizard:

Image

When reading the Excel Sheet with EPPlus angle brackets are somehow encoded, probably it’s XML-Encoding.
If the Excel Sheet created by Access then is opend in Excel and saved again (“file touched”), EPPlus reads it as it should be.

Image

Please help me to solve this issue. Does Access create invalid Spreadsheets? Is there something missing in EPPlus? Same behavior with Spreadsheets created by Access 2007 and 2013.

Excel always shows the correct text, also reading the Spreadsheet with SQL Server (using OPENROWSET) shows correct texts.

AccessExport.xlsx
SavedInExcel.xlsx


Thanks,
Benjamin