run-sql-query-using-vba-simplemsoffice

How to Run SQL Query Using VBA Script

Here is a simple VBA macro code to run SQL Query from excel. And you can assign a command button to execute your query. Also, you can get the output of that query in your excel sheet very easily. So for example let the Server name as sql_server_name, the Database as database_name, and TableName as […]

Read More
basic-sql-commands-simplemsoffice

Basic Commands in SQL for Beginners

I am sharing some very important SQL Commands at the beginner level. These commands are very common and useful in everyday office work if you are using SQL. So, I am sharing different types of commands with syntax. Basically, SQL is a Structured Query Language or you can say Standard Language for accessing and manipulating […]

Read More