GitHub

Excel VBA macro which run SQL to CSV file and to Excel file.

With this excel macro, you can run SQL to any text file (need to be either csv or tsv format), and get the result to the excel sheet or can export to csv file. It also contains "automation" ...
Microsoft

Running a SQL Stored Procedure from Excel (No VBA)

Today’s author is Mike Alexander, an Excel MVP who shows us how to run a Stored Procedure to get data from a SQL server. We all know we can use MS Query to get data from a SQL server. Typically though ...
GitHub

Excel VBA × PostgreSQL 在庫・売上管理システム

ExcelVBAとPostgreSQLを組み合わせた在庫・売上管理システムです。 実務で培ったVBAスキルとSQLの学習成果をポートフォリオとしてまとめました。
The Earth Institute Columbia University

Coding for Risk Management Seminar, Presented by the ERM Program

The Coding for Risk Management Seminar workshops get you started in Excel, VBA, R, Python, SQL, and GitHub. The first step in all of these languages is a big step; after taking it here, you will be ...