| Contact Us |
Excel Tool SQL Query is a add-in for Excel that allows you to query using SQL within the Excel application itself.
It can run a SQL Query on an Excel Spreadsheet. You may use the SQL statement every day to search the data in ACCESS, and then import the data in ACCESS to EXCEL, handwriting SQL sentences searching is both time-wasting and it's a hard sledding, also it is easy to get wrong, this software can solve the listed problems. It allows you to create SQL queries by clicking and arranging visual elements instead of writing SQL code even if you don't understand SQL. It can query Access, Excel Using SQL and execute SQL insert sheet for excel data in seconds. With the software you will spend less time, effort and frustration moving data between your Excel and Access.
This Excel Tool SQL Query software's advantages:
Easy to manipulate, even if do not know SQL it is also very easy to use.
Powerful, you can generate most of the SQL code by setting.
If you became very familiar to this tool then you are very familiar to SQL sentences.
With Excel Tool SQL Query software you can:
Query Access Data Using SQL.
Query Excel Data Using SQL.
Filter the Access/Excel Data In Excel.
Sum Data By Fields.
Merge Multiple Sheets.
Merge Excel Files On Same Path..
Split Excel Sheet by Fields.
Current Version: 2014.7.20
File Size: 2.73(MB)
Software requirements: Microsoft Excel 2000/XP/2003/2007/2010//2013
Sum Access Data By Fields. Video Tutorial: Sum Access Data By Fields.avi
Sum by 'ProductID'
Filter the ACCESS Data Video Tutorial: Filter the ACCESS Data.avi
(ProductID='A1006' And Country='USA')
Merge Multiple Sheets Video Tutorial: Merge Multiple Sheets.avi
Merge Worksheet USA, Worksheet Spain, Worksheet Netherlands, Worksheet Germany, and so on.
Split Table by Fields Video Tutorial: Split Table by Fields.avi
Split Sheet Report by Country Fields.
Create Two Dimensional Table Video Tutorial: Create Two Dimensional Table.avi
Set ProductID to (Column Fields), Set Country to (Group By), Set Quantity to (Sum)
Advanced Filter ( Query A1003, A1006, A1009 ) Video Tutorial: Advanced Filter.avi
Query these ID: A1003, A1006, A1009
SQL Lookup Video Tutorial: SQL Lookup.avi
Export 'Mode' in worksheet A to worksheet B.