Data blog — sql query RSS

Write Select Statements for Excel Spreadsheets

You are reading this post because there is a chance you want to compare two spreadsheets in Excel, and you are looking for a way to do it easily and effectively. SelectCompare allows for data comparison of Excel spreadsheets, as well as other data sources with simple, unified interface. You can export your comparison to Excel for further analysis or sharing. You may be initially anxious about writing an SQL statement to pull data from your Excel, but unnecessarily. It is not that difficult! This post will show you a few examples of writing queries against your spreadsheet that you will be able to use right away for your Excel data comparison. If you want to find out how to connect...

Continue reading

Compare Excel Spreadsheets

Comparing Excel Spreadsheets - Why? Business and Data analysts, Developers and QA testers often have to verify their data is correct. Microsoft Excel is used to create a snapshot of "good data". Reports are captured and copied into Excel, data is exported and distributed as the model to use. SelectCompare allows you to compare Excel spreadsheets in the same way as other data sources. This post is going to show you the process of creating data connections to Excel workbooks and comparing data between two spreadsheets. Where do I start? First, you have to install appropriate driver to connect to the Excel workbooks. It is an easy step to get you up and running. Install drivers First thing is to install the...

Continue reading

SQL Data Comparison - User Manual

You visit this page because you know how to write a SQL query. Learn how you can use your expertise to do your work better and save your time! The Idea The SelectCompare idea is very simple: write an SQL query to extract data to compare on each data source. With SelectCompare, you create comparison projects that define data connections to each of the data sources and you write SQL queries for these data connections. You can create data connections separately from comparison projects, and reuse data connections in multiple projects. This is a quick manual that will show you how to compare data using SelectCompare. Step by step When you launch the program, you are presented with the page containing all defined comparison projects. Initially...

Continue reading