HomeНаука и техникаRelated VideosMore From: Excel Ideas and Solutions

How to build multi record INSERT and UPDATE SQL query with MS Excel

23 ratings | 14794 views
The video shows how to use Microsft Excel to prepare / build / construct SQL INSERT and UPDATE query / queries for multi / many records / rows of data. It can be especially useful for UPDATE clause queries because INSERT type has alternatives methods in provided SQL tools. It also demostartes the general usage of method to multi build queries with the usage of concatenate function. More examples on: http://www.excel.sos.pl Tags: MS SQL, My SQL, MS Excel, Oracle
Html code for embedding videos on your blog
Text Comments (2)
Nelson Costa (1 year ago)
can share the code?
Hello Nelson, first you have to display Developer tab in excel. Then inside the Developer tab, navigate to macros and then on the only one available click Edit, Best regards

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.