how to import excel data in database

Question

excel entry to database

Puneet Kankar · Answer

Hi Dip, Follow given below links for import excel file in MySQL. https://dev.mysql.com/doc/mysql-for-excel/en/mysql-for-excel-import.html https://www.youtube.com/watch?v=zE1qMRdgkKU https://www.databasejournal.com/features/mysql/importing-xml-csv-text-and-ms-excel-files-into-mysql.html https://stackoverflow.com/questions/1310166/how-to-import-an-excel-file-in-to-a-mysql-database

Sapna Girish · Answer

If you use Sprie.XLS for .NET, you can easily export data from Excel sheet to datatable by Worksheet.ExportDataTable method. //Create a new workbook Workbook workbook = new Workbook(); //Load a file and imports its data workbook.LoadFromFile(@”..\FandH.xlsx”); //Initialize worksheet Worksheet sheet = workbook.Worksheets[0]; // get the data source that the grid is displaying data for this .dataGridView1.DataSource = sheet.ExportDataTable();

Rupesh Kahane · Answer

For PHP refer below links 1) https://www.ybierling.com/en/blog-web-importexcelfilemysqldatabasephpmyadmin 2) https://davalign.com/articles/import-excel-data-into-mysql-using-phpmyadmin/

dip vyas · Answer

i want to import file in phpmyadmin

Rupesh Kahane · Answer

Refer below links 1) https://www.c-sharpcorner.com/article/how-to-import-excel-data-in-sql-server-2014/ 2) https://stackoverflow.com/questions/39610133/how-to-import-an-excel-file-into-sql-server 3) https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-data-from-excel-to-sql?view=sql-server-ver15