within the IDE) but fails when the compiled executable is run independent of the IDE. However, it has worked for a few years until recent Microsoft updates were applied.Ī second observation is that this code works on a computer without all the similar updates when run in debug mode (i.e.
This code consistently fail on the line 'oda.Fill(tbContainer)'. If (string.IsNullOrEmpty(sheetName)) $]', sheetName), cnnxls) Private DataTable ExcelFileToDataTable(string pathName, string sheetName) net framework changes or something else. It is unclear if this is due to an oleadapter update, xlsx) and these worked for years but it appears that after multiple updates in the past year, the ole adapter fill now raises an exception. We have some oledb code for reading excel files (both.
