ExcelDBTools

Have you ever found yourself using the built-in database connection feature of Excel, only to realize that it is very cumbersome to use? Have you ever wished you could retrieve data from a database or another Excel file as simply as a built-in function? The wait is over. We, at Exis, LLC, went through the same pains and decided to solve this problem once and for all. Excel DB Tools allows you to connect to relational databases or another Excel spreadsheet and create your own custom Excel functions without having to know relational database query languages, and retrieve data simply by providing the parameter values of your functions either by reference or by value. The custom functions you create using Excel DB Tools work and behave the same way built-in Excel functions work. For example, you can fill down your function the same way, you can hit F9 or Shift+F9 to refresh the calculations the same way, etc. We are sure you will love it. We are here to help so if you have any suggestions, we love to hear them to make this tool even better and more useful.