programs, utility, tools, application

run SQL query from Excel

SQL query from Excel, SQL query to Excel, SQL queries in Excel, run SQL query from Excel, program for SQL query from Excel


Theme of our material is SQL query from Excel and using SQL in Excel. We will explain how to create SQL query to Excel. We think that it is time to understand this process and to make it accessible for all persons interested. SQL is the information and logical language intended for the description, change and extraction data, kept in relational databases. Initially SQL was the basic mode of work with a database for user and it allowed carrying out the following operations: creation the new table in a database; addition new records in the table; change records; removal records; sorting records in one or several tables. Now there is program Access for work with a database. The basic object of storage relational database is the table; therefore all SQL-queries are operations with tables. According to it, queries are divided into: the queries operating with tables (creation and change tables); the queries operating with separate records or sets of records.
(more…)