I populate spreadsheets with data retrieved from an access db using ADO via
an excel form. Connection string used is, strdb =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDbPath & ";Persist
Security Info=False"
I then access the spreadsheets via a .NET application and load various excel
row values into variables to be used by the application. ADO Connection
string used is,
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel
8.0;HDR=No;IMEX=1;". The cell format in all cells in all spreadsheets is set
to Text. The problem I am having is that cell values occasionally get ignored
when reading rows via my .NET app. For example if I have a row, row 10,
A10="A10 cell value",B10="B10 cell value",C10="C10 cell value". I can see
the values in the spreadsheet, but when I loop through the cell values via my
..NET app sometimes only cells A10 and B10's values will be retrieved. This
does not always happen. For example a previous row may have 10 cells that
have values and all are retrieved correctly by the application. Hopefully i
have explained myself properly and any ideas would be greatly appreciated?