How do i update database table by exporting data from excel

Question

I have a table which already have data in it. I have a excel file which has updates list of data for the table. I need to map the data in database table and i have to insert the rows which is not in database. How do i do this operation

Manish Kumar · Answer

Do following steps. (Assuming you are working on Sql Server) --Import your excel data to sql server in a new table. --Look for merege statement in sql server .Check below link https://www.mssqltips.com/sqlservertip/1704/using-merge-in-sql-server-to-insert-update-and-delete-at-the-same-time/ Thanks Manish

Istudent Rana · Answer

I Know basic by using import export wizzard tools. But in my case i need to check up the column and data . If it already exists I want to run update query and if not then i want to insert.

Sagar Pandurang Kap · Answer

Hi For MySql follow below link : https://dev.mysql.com/doc/mysql-for-excel/en/mysql-for-excel-export.html For Sql Server follow below link :- https://www.mssqltips.com/sqlservertip/1540/insert-update-or-delete-data-in-sql-server-from-excel/ Hope it helps