Exporting 100,000+ rows to excel
624226Jun 20 2008 — edited Jun 20 2008We have a SQL SELECT statement that we wish to export to excel. We are using TOAD but to be blunt is rubbish at this. It first reads everything into memory which so far is using almost 1GB and has taken over 24 hours. The computer is using most of its time allocating memory! Does anyone know of any tools which take a SELECT statement and create a excel file without loading all the data into memory?