Tag Archives: ODBC

Excel: Prepare to Connect to the Database from VBA


Here’s the way to connect to the database from Excel VBA. (Excel から VBA を使わずにデータを取得・表示する方法もあります。 例: Windows, Excel: データベースから直接値を取得して表示する)

Continue reading Excel: Prepare to Connect to the Database from VBA

Windows, Excel: Connect Database Directly and Show the Data


Here, I introduce the way to show the database records in Excel directly. In this article, I’ll show you the way using ODBC connection. (There are other ways.)

Continue reading Windows, Excel: Connect Database Directly and Show the Data

Windows: Set up PostgreSQL ODBC Data Source


Here is the way to set up PostgreSQL ODBC Data Source in Windows.

Continue reading Windows: Set up PostgreSQL ODBC Data Source