How can the .cells help with importing large quantities of records into sql from Excel, or cant it. I am exploring the use of a third party tool and have been imporessed with the PDF tool. Would like to purchase this week but want toed to know if its worth downloading. Thank George
This message was posted using Aspose.Live 2 Forum
Hi George,
Thanks for considering Aspose.
Aspose.Cells for .NET does support to export data from Excel spreadsheets to DataTable and Arrays. So, I think you can just export data to fill a datatable or array using Aspose.Cells APIs and then you can insert/update your SQL database with the data in the datatable/array by using .NET APIs.
See the document for your reference:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/exporting-data-from-worksheets.html
Thank you.