Return
-
Title
Import Table Data can show misleading data in preview -
Description
When importing data from within Toad using the Import Data Wizard, the preview results window is misleading.
1. Create table with column type = number
2. Create txt or xls file with data in the form 10,42
3. Import data from txt or xls file with Decimal Symbol = “.”
4. Preview Results displays a value of 10,42
5. Value imported into db = 1042TOAD OPTIONS SETTINGS NOT REFLECTED IN IMPORT SETTINGS
1. In Toad Options set Decimal Symbol = “,”
2. Import data from txt or xls file
3. Observe that Decimal Symbol still = ‘.’
-
Cause
The preview window is previewing the data in the import file, rather than the expected data within the table.
-
Resolution
WORKAROUND:
Ensure that the decimal separator in Toad import is set to the same character used in the data file being imported.
e.g. data file contains 10, 42 ensure decimal separator = ‘,’STATUS:
Waiting for a fix in a future version of Toad for Oracle -
Defect ID
ST85503