Can't limit number of rows to import

Toad Data Point
1

When I try to import data I only have an option for which row to start at, not to limit how many rows to import. Consequently, it imports my (for example) 2 rows and then about 7700 null rows. I have looked around and the only things that I can find show the ability to limit the number of rows, but this is not in my dialog. Am I missing something here? Thanks.
#confusedInAnnArbor

EDIT: I do see why I am getting all of these. Because the CSV has tons of null rows. But according to all that I can find, I should be able to limit how many rows to import...

2

Hi Isaac,
do you see this in Import Wizard?

image
image.png880×209 10.3 KB

Which TDP version are you using?

3

No I don't see this at all. I am using Toad 4.3.

image
image.png1336×871 51.2 KB

4

Oh, for CSVs the import dialog is different. My screenshot was Excel file. As a workaround, can you use XLSX for importing?
I'll investigate whether it's possible to add an enhancement request.

5

Ah. I kind of wondered that when I saw you were doing excel. Odd that it would be different. But yes, I can upload it as excel. I'll give that a try. Thanks.

6

Added an ER QAT-15164 to add "End row" for import of CSVs.

7

Thank you kind sir :slight_smile: