by Tito | Nov 20, 2020 | Excel2SQL
Change is part of life and our data is extremely susceptible to these changes. Can Microsoft Excel Keep up with all of the changes to your data? Maybe it’s time to use SQL to update your data. Let’s discuss updating data in an effective way. Up until now, many...
by Tito | Oct 29, 2020 | General Productivity
The ability to format and manipulate Excel character strings is extremely important for data analysis. SQL String functions are useful for querying and manipulating data. Luckily for you, this article will solidify your string function knowledge in both applications....
by Tito | Oct 16, 2020 | Excel2SQL
Most of my readers are heavy Excel users. Today we will transition our strong Excel foundation into learning another complementary tool, SQL Databases. Here are a few components that are fundamental to Databases and SQL. Tables – Other concepts could come first,...
by Tito | Oct 10, 2020 | Excel2SQL, Popular
Let’s discuss why Excel Users should learn SQL to pull their own data. First, we will answer the basic question, What is SQL? SQL stands for Structured Query language. It is used to manage structured information in database tables. Structured data is formatted...
by Tito | Oct 3, 2020 | Excel2SQL, General Productivity, Popular
Export SQL Data to Excel from Microsoft SQL Server Let’s go over three ways to export an SQL Query to an Excel File Using MSSQL Despite the pushback from Database aficionados, sometimes it makes sense to export data from SQL to an Excel file. It really depends...