paoconnell
Programmer
We are using an Excel spreadsheet (with a single sheet) as a data file, with a number of columns containing Boolean (TRUE/FALSE) cells. We read the file using VB6 and ADO. For some reason, ADO retrieves some TRUE Booleans as FALSE or Null. In a few cases, FALSE values have been retrieved as Null.
The best way I've found to fix this problem is to save the sheet with the problem as a CSV file, then confirm that the cell(s) with the problematic TRUE have been exported correctly and fix as necessary. Open a new spreadsheet (we weren't using formulas, so this wasn't a problem) and load the CSV file, then save the spreadsheet.
Pat O'Connell
The best way I've found to fix this problem is to save the sheet with the problem as a CSV file, then confirm that the cell(s) with the problematic TRUE have been exported correctly and fix as necessary. Open a new spreadsheet (we weren't using formulas, so this wasn't a problem) and load the CSV file, then save the spreadsheet.
Pat O'Connell