Posts relating to Excel and SQL
Basic Solver
Strategies The first step is to put together a basic solver. In Sudoku, there are 3 Regions – Row, Column and Box, but you probably know that already if you are reading this. Other terminology […]
Posts relating to Excel and SQL
Strategies The first step is to put together a basic solver. In Sudoku, there are 3 Regions – Row, Column and Box, but you probably know that already if you are reading this. Other terminology […]
What can you learn here? Library of ADODB connections Populate from databases Use SQL on closed workbooks A library to populate Excel tables with SQL query results get it now Using SQL to populate Excel […]
bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines