When trying to import data using an import template, I get the following error in the event log:
3:59:29 PM Thread (24) Importing 186 out of 292 files
3:59:29 PM Thread (24) Reading from file Copy (5) of U_Copy (13) of tstlck.xlsm
3:59:30 PM Thread (24) Exception of type ‘System.OutOfMemoryException’ was thrown.
3:59:30 PM Thread (24) Nothing to discard, delete C:\Documents and Settings\sanchezr\Desktop\ITALY_EXTRACT_STAGING\U_Copy (10) of tstlck_rows_with_error.csv
3:59:39 PM Thread (24)
Imported rows were rolled back.
3:59:39 PM Thread (24) Error importing data, please check file format options: Exception of type ‘System.OutOfMemoryException’ was thrown.
The template is designed to go against a folder and extract data from several worksheets that are in the workbooks files in the folder. I’ve confirmed that it does about 20 workbooks files without problem but when I get up to 200 files, it starts to throw this exception.
Any ideas on what’s causing it? I’ve attached the template that I’m using.
TEST.tim (12.8 KB)