SQL Server allows us to read and import files at will without the use of SSIS (Integration Services) and Wizard packages. This process is done using the OPENROWSET function and the BULK INSERT. We can… read more
How can we export daily data from SQL Server to Excel and email it
In the daily operations of companies it is often necessary to extract daily data from the database and give it to an Excel. In these Excels we usually want to have some specific name along with a date and to… read more
How to load data into Microsoft Excel from a database using Power Query
Microsoft Excel one of the first Microsoft programs. From its first versions, it had the ability to collaborate with software from other companies. In this article we will explore how to connect Excel to any… read more
Useful VBA routines in Microsoft Excel (Part 2)
In continuation of the previous article we will see some more VBA (Visual Basic for Applications) routines that we can use in Microsoft Excel. These routines can be executed by calling them on a button or after some… read more
How do we connect a Microsoft Excel to SQL Server
Microsoft Excel, although we use it every day and is one of the most well-known and oldest Microsoft programs, hides many possibilities. In this article we will see how to connect a SQL Server database... read more
How to make charts in Microsoft Excel using Python
In Microsoft Excel, in addition to using functions and pivoting, we have the possibility to add graphs based on this data. But we know that graphs can also be made using Python with libraries such as matplotlib and seaborn.… read more
Useful VBA routines in Microsoft Excel (Part 1)
We have talked in a previous article about what VBA (Visual Basic for Applications) is and what possibilities it has within Microsoft Excel. In this article we will look at some routines I have written that can be executed by calling the… read more
How to record who last modified the record in shared Microsoft Excel
We all know Microsoft Excel as one of the most basic and first programs created for use with a graphical environment on computers. Many times we have a shared Excel file that is being edited by multiple users. Maybe for… read more
Pivoting in Microsoft Excel using Python
In an earlier article we have seen the possibilities to perform Excel functions such as vlookup through Python. In this article we will see how we can perform pivoting through Python. We will analyze ways so that we can find information… read more
