note

【VBA】Excelファイルを開かずにデータをSQLで取り出す

指定したExcelを開かずに参照するマクロです。 指定したExcelの「Sheet1」A1～F15内で、A、C、E列のみ、マクロを組んだExcelに転記します。 SQLを使ってます。ADOを使って、VBAからExcelにSQLでアクセスする方法です（VBA、ADO、SQLの応用です）。 参照対象のExcelは ...
TWCN Tech News

How to insert Timestamp in Excel and Google Sheets

In this post, we will show you how to insert Timestamp in Excel & Google Sheets. Microsoft Excel and Google Sheets support two types of timestamps: Static and Dynamic. Static timestamps do not update ...
GitHub

MazahirHaroon/Read_Excel-Codeigniter

A controller function 'updateTable' to read excel file and create an array of arrays. A modal function 'updateCityTable' to insert the array to the database table. A test excel file 'test_data' with ...
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 ...