Free Support Forum - aspose.com

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.

Thanks
Dave

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.