the PostgreSQL one if the instructions here were applied, and extract the content of the tables, as shown below: $ psql sampledbĪnd so on with the other tables locations, departments, jobs, employees and dependents.

We will just query an existing database, e.g. Let’s create a spreadsheet with the data sample from the site. This is quite self-evident see the screen copy down below.Īs the Excel sheet is the database, there is no server software to install but only the ODBC drivers. The first row of a sheet contains the column headers. The idea is to access spreadsheet files as if they were relational databases, each sheet being a table, each line a table’s row and each column a table’s column. Like MongoDB, Excel is not a relational data source, but the ODBC API will allow to access its data using SQL statements. The test system is a debian v11 (bullseye). Refer to SQLite for installing the required ODBC Driver Manager. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, HSQLDB, MongoDB, and MariaDB.

Excel driver for odbc download