Free Support Forum -

Importing Multi worksheet Excel into SQL server

Will aspose.Excel allow me to import data from multiple worksheets using ASP.NET into SQL server tables?

If so will I need to set any specific permissions on my web server other than allowing asp net security to read and wirte files to a specific directory on my meb server.


Sure you can.

If you want to import data from worksheets and populate data to SQL server tables, please use the following steps:

1. Use Excel.Open method to import an excel spreadsheet.
2. Use Cells.ExportDataTable method to export data of the worksheet to a datatable.
3. Populate data into SQL server tables.

Hi Dave,

You don’t need to set any specific permissions other than allowing Aspose.Excel.dll to run on your machine and to read/write file to a specific directory.