Import from Excel - very slow

Toad for Oracle & DevOps Toolkit
1

Hi,
I am on 16.1.53.1594.
I am trying to load file with about 20K records and it takes almost an hour to load.
No constraints are enabled and no indexes are active.

Same file gets loaded in less than a minute in SQL Developer.

What could be the issue?

2

Did you check this box? You should. It makes all the difference for speed.

image
image571×594 19.6 KB

3

Yes, i did not try it, but did not work.

4

Sorry,
I DID try it and it did not help.

5

I'm not sure what could be the problem then.

I just tested with a copy of dba_source. I was able to import 20,000 records in 6 seconds.

I'd be happy to try with your excel file if you want to send it to me.

6

Thanks for all your help. Appreciate it.

7

We were able to reproduce hour-long imports with your file. This is a bug and it will be fixed in version 16.2.

Until then, as a workaround, when importing data with dates from Excel files, make sure that Toad's date format in Options -> Data Grids -> Data matches the format in Excel, and then it will be fast.

8

Thanks for your time on this

9

You're welcome. Sorry you had such slow imports. :frowning: