Excel

Export MariaDB (MySQL) database table to a CSV or spreadsheet file

In this tutorial I’ll show you how to export MariaDB (MySQL) database table data to CSV format on an external file (The CSV format is potable and can be used across multiple applications especially spreadsheet applications like Excel, LibreOffice Calc) using phpMyAdmin. Steps followed by this….

Read more Export MariaDB (MySQL) database table to a CSV or spreadsheet file

Export PostgreSQL database table data to spreadsheet

In this tutorial I’ll show you the easiest way to export PostgtreSQL table data to CSV format on an external file (The CSV format is potable and can be used across multiple applications especially spreadsheet applications like Excel, LibreOffice Calc) using PostgtreSQL SQL COPY command. Steps….

Read more Export PostgreSQL database table data to spreadsheet

Importing data from spreadsheet (Excel, LibreOffice Calc, CSV) file into PostgreSQL database table.

In this tutorial we will import data from spreadsheet (Excel, LibreOffice Calc) file into PostgreSQL database table using PostgtreSQL SQL COPY command. For PostgreSQL 9.0 or heigher. .

Read more Importing data from spreadsheet (Excel, LibreOffice Calc, CSV) file into PostgreSQL database table.

Oracle reading data from spreadsheet file using external tables

Oracle reading data from spreadsheet file using external tables This method can be useful to read data from fingerprint device or read data from another data sources..

Read more Oracle reading data from spreadsheet file using external tables