Are there any samples of how to import an excel file to sql server?
I’m new to this product and would prefer to use in instead of ssis.
If there are no examples, where in the documentation should I look,
I’ll be controlling this via a .net app.
Any help would be appreciated.
Thanks
Thanks for your query.
Well, Aspose.Cells does support to import/ export data from/ to a variety of data sources. Please see the documents for your complete reference:
As you need to update database (SQL Server) tables with your worksheet data, you will use the relevant Aspose.Cells APIs (data exporting options) to fill data tables or (export worksheet data to) arrays and write your own .NET code to insert/update your database tables’ data with data table/ arrays etc., see the second document (above) with examples for complete details.
Thank you for the locations to look in!