Toad World® Forums

Export To Excel

Why does export to excel take a long time to complete on toad expert Granted there are 50-60k rows but takes 1hr and locks up the session. This kind of thing was faster with previous version of toad. I have the 64Bit version on Windows 7. Anything that I need to do to make excel exports run faster?

This is the first I’ve heard of any slowness there. Do you still have whatever old version of Toad you are referring to installed to make sure it hasn’t slowed down too? I just exported the contents of DBA_OBJECTS to an xlsx file and it took only a few seconds.

If you are exporting from a grid, make sure to have the “Display all results in grid” option unchecked. That can make a big difference in speed (but probably wouldn’t explain one hour).