After using Import Table data to import data from an Excel sheet, the casing for the entries "TRUE" or "FALSE" are changed to mixed/init caps. This is only an issue with the terms true and false.
Example:
Excel file written to and saved with data like:
TRUE
FALSE
true
false
'TRUE
'FALSE
Data in database after import through Toad's Import Table Data:
True
False
True
False
'TRUE
'FALSE
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center