I am getting a System.OutOfMemoryException error when trying to import data into a table with a lot of columns (200+). I was trying to import 452 when getting the error message. I was able to import 350 records, but anything over that number gave me the out of memory error.
WORKAROUND:
Break up the records you are trying import into different spreadsheets to a number of records that TDA can handle.
STATUS:
Waiting for fix to be released in a future version of Toad for Data Analysts.
