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?

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 …

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

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

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.

Thanks for all your help. Appreciate it.

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

Import from Excel - very slow

Toad for Oracle & DevOps Toolkit

JohnDorlon September 12, 2022, 5:01pm 2

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

Topic		Replies	Views
Import Excel spreadsheet with dates Toad for Oracle & DevOps Toolkit	4	2568	May 18, 2022
Excel file connection speeds Toad Data Point & Toad Intelligence Central	1	192	February 2, 2024
Import a large csv data into a database which contains foreign characters Toad for Oracle & DevOps Toolkit	1	1321	September 17, 2020
Toad export excel slowness problem Toad for Oracle & DevOps Toolkit	24	2457	September 19, 2020
Export to Excel taking too much time Toad for Oracle & DevOps Toolkit	4	3382	April 19, 2018

Import from Excel - very slow

Related topics