Microsoft’s SQL Server is the database solution of choice for our company. However, like many of the database solutions available, additional data mining tools are required to provide the top level reports needed to manage the business itself.
Not surprisingly, one of those tools is Excel 2016. The correlation between a database table and a spreadsheet is intuitively clear. While it is easy to conceive how they may be related, connecting the two may be a daunting experience the first time around.
For someone looking to make a quick connection, we recommend visiting the datapig technologies blog (http://datapigtechnologies.com/blog/). In a matter of minutes, you can establish a connection to your database and dynamically refresh the data on your spreadsheet.
Until Next Time, STAY lean!