Toad World® Forums

Toad Data Point - Import Wizard

Hello,

I am using Toad Data Point - Import Wizard Template for loading data into Teradata from excel file. I would like the load to fail if there is any bad data entered(ex: string field into a decimal field) in the excel file, but the load seem to skip the batch and continue to the next batch without failing. Any help is appreciated !!!

Thanks

Are you importing the Excel file to existing table or a new table? I didn’t quiet understand “the load seem to skip the batch and continue to the next batch without failing”, can you give me some example? If you can forward me your import template and sample Excel file, I can investigate this for you.