Uploading Large Excel File

Uploading Large Excel File

I am using ExcelToRecordList to convert the uploaded Excel file and iterate them to insert each of them into the database. Using a small dataset I am good. But with a full load of 25MB Excel file, it times out.

I checked on using a Process but a List or Binary is not allowed to be used as a parameter for it.

I'd store the Excel file as-is in a temporary table, and kick off a timer that reads the table, and uses ExcelToRecordList to convert it and then process it. If the timer times out, you can always increase its run time.