Loading

Saving Excel File

Rosmieza Rosli

I have a datagridview populated by import data from excel file. Now I need to save this to database explore or to mysql server. This process will be repeated daily and data will be consistently added to database so I believe there would be INSERT query. Could you please tell me main steps to follow?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gowtham Rajamanickam11y ago
https://code.msdn.microsoft.com/office/CSASPNETExcelImportExport-71cf1101
Gowtham Rajamanickam11y ago
http://stackoverflow.com/questions/464902/how-to-open-an-excel-file-in-c
Gowtham Rajamanickam11y ago
http://support.microsoft.com/en-us/kb/306572