Start a modern, modular successor to TheBigOne (side-by-side; TheBigOne
untouched):
- Sql.bas: stateless SQL-text generation from a 2D Variant array (header
in row 1). Type inference from Excel cell VarType, dialect-aware
identifier quoting/literals, VALUES batch + INSERT...SELECT, and
CreateTableIfMissing. Successor to the SQLp_* helpers.
- Db.cls: single connection object, late-bound ADO (no reference needed),
SQLOLEDB by default (zero-install / non-admin friendly). Open/Exec/Query
with structured LastError. Successor to the ADOp_* helpers.
- TBFCLoad.bas: thin caller that loads the "Upload" tab into
fanalysis.GS.TBFC (auto-create, replace-by-Source). Tested vs USMIDSQL01.
- load_tbfc.py: equivalent Python loader kept as a power-user alternative.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Paul Trowbridge
3e5a31a5bf