Convert Excel to SQL statements

Hello.


I am new to Aspose and was told that the program can take excel files, read them, and then import that data into a sql server database.

In general terms, what is the coding process that I would use to accomplish this? Example answer could be that I simply use the Apose Cells api to read the spreadsheets then use ADO.Net to move the files into the database.

Thanks.

Hi,


Thanks for your posting and using Aspose.Cells.

You can export or import worksheet data into DataTable. Once you have DataTable, you can export it to database using ADO.NET.

Please see the following two articles related to this topic.

http://www.aspose.com/docs/display/cellsnet/Exporting+Data+from+Worksheets
http://www.aspose.com/docs/display/cellsnet/Importing+Data+to+Worksheets