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

obyxs · March 20, 2006, 3:16am

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.

Laurence · March 20, 2006, 5:03pm

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.