Group,
I’ve got a very large Excel file that is holding about 50 Meg of data that I need to upload into my schema. I can’t seem to get this to happen as I see at the top that the program is “Not Responding” when I attempt to do the load via the “Import Table Data” option. Is this because there is a limit to size of the file I’m using for the data?
In advance, thanks for the assistance.
Don
On large XLSX files, sometimes it takes Toad a while to open them. I believe it will finish if you just let it keep working (it’s still working when you see “not responding”)
If you have an option of getting this file as a comma-delimited text file (maybe you could save it to that format from Excel - any delimiter would be fine), then that might go faster. Another thing that might make it go faster is if you can save the file as XLS rather than XLSX - although maybe that’s not an option if you have more than 65536 rows in your spreadsheet.
Also, if you have the option of upgrading your Toad, it will probably go a lot faster in 12.8 due to some improvements in our Excel read/write component.