Which is better SQL or VBA?

Question

At the very simple level SQL is easier than VBA but it rapidly gets harder than VBA as the SQL queries get more complex. Whereas VBA starts hard but then doesn't get much harder. 6 июл. 2015 г.

Is SQL different from VBA?

While Visual Basic (VBA is an implementation of Visual Basic) is a general-purpose scripting programming language, SQL is a special-purpose programming language- aimed at running queries and CRUD (Create, Read, Update, Delete) operations on relational databases such as MySQL, MS SQL, Oracle, MS Access etc.

Is SQL harder than Excel?

Both tools have their own learning curve—although many claim SQL is more difficult than Excel. That said, learning one tool may make it much easier to learn the other. Most data analysts learn both Excel and SQL.

Does VBA have a future?

VBA is not the future, definitely. But VBA support will continue till Excel / Office is continuing. There are 100s of millions lines of VBA code supporting very critical processes. This issue has been discussed almost every year and outcome is that VBA will continue.

Expert · Answer