Return
-
Title
Export to Excel reads boolean data backwards, what is true displays as false -
Description
In Toad for Data Analysts, I'm connecting to a SQL Server database where a table has a boolean data type (BIT). When I query the table and then try to export to an Excel File, I notice that the data results are backwards; what is true displays as false and visa versa.
-
Resolution
WORKAROUND:
Use the Export to Excel Instance and the data will be exported correctly.