Toad World® Forums

Remove NULL ROWS using Import Data


#1

Hi,

I tried to import a Excel file into a Table using the “Import Table Data” component of Toad for Oracle.

During the setting i don’t see a way to remove the null rows.

The only thing that i can use to restrict the input is “Last row”.
I can’t use "Last “Row” because the Import step is performed for file with various number of rows.

Is there a way to remove this null rows ?


#2

So you just have some blank rows in the middle of your data? Sorry, there’s no way to exclude them from Toad (other than let it throw an error on those rows and then continue). Maybe there is some trick in Excel you can use to clean the data before importing.