How do i update database table by exporting data from excel

Manish Kumar8y ago

Accepted 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

0

Istudent Rana8y ago

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.

0

Sagar Pandurang Kap8y ago

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

0