Read Excel File content from Folder to MYSQL databa

Hi,

 

Please use this link which will help you out,

 

https://www.c-sharpcorner.com/blogs/import-and-export-data-from-excel-to-database 

https://stackoverflow.com/questions/34238675/how-to-upload-a-excel-file-to-sql-database-table-using-c-sharp-windows-form-appl 

Check these thread:

https://stackoverflow.com/questions/15760932/import-data-from-excel-to-mysql-using-c-sharp 

https://www.daniweb.com/programming/software-development/threads/431423/how-to-import-excel-to-datagrid-then-save-to-mysql-database-c 

you can read excel data using OleDbConnection and prepare DataTable

 

https://geeksarray.com/blog/display-excel-data-in-web-page-using-aspnet-csharp

 

Once your DataTable is ready you can use ADO.NET or SQLBulkCopy to move data to SQL server

 

https://geeksarray.com/blog/bulk-upload-into-sql-server-using-sqlbulkcopy-and-c-sharp