Excel and SQL Archives - Desktop Liberation

Random blog posts

Basic Solver

March 30, 2019 Comments Off

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 […]

All formats are available from O'Reilly, Amazon and all good bookshops. You can also read a preview on O'Reilly

A video course over about 8 hours and 70 lessons taking you through the basics of Apps Script and JavaScript. Available at O'Reilly, Amazon, Infinite Skills & all good media outlets

Google Apps Script for Beginners: A video course over about 8 hours and 70 lessons taking you through the basics of Apps Script and JavaScript. Available from O'Reilly, Infinite Skills and all good media outlets

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

Desktop Liberation

The definitive resource for Google Apps Script and Microsoft Office automation

Excel and SQL

Basic Solver

Execute SQL from Excel