Pre-Sales Question - Import SpreadsheetML into SQL Server

Hi Mike,

Thank you for considering Aspose.

As your file is a very large excel file and it will require a lot of memory to process if you will try to fetch the data and load it in one go and this will cause the “Out of Memory” issue. As per my understanding, you have two options in this case, either you can break down your Excel file in to different small files and load them one by one or you can Export a limited number of rows to your datatable and bulk copy them segment by segment to the database.

As per the memory issue is concerned, we will further look into it.

Thank You & Best Regards,