Export a Excel File into a SQL Table- demo please?


#1

Hi.

I want to export all the information inside in excel file into a sql table, can u tell me an example and how to do this?? Im so lost right now.


#2

You can use Cells.ExportDataTable or Cells.ExportDataTableAsString method to export data from Excel file to DataTable. Then you can put those data into your database.