Creating SQL Scripts(insert,delete,update) using Excel

preview_player
Показать описание
When we have bulk data in excel and that needs to be updated in Database in this case we can use excel to create sql scripts(insert,delete,update,create). This is really simplifies the process
Рекомендации по теме
Комментарии
Автор

Please suggest the formula if the query contains date
I.e date of birth : 01/04/55 using this formula the date becomes 550401 instead of proper date

gubluuk