Import Excel Data into PostgreSQL 9.3

The typical answer is this:

1. In Excel, File/Save As, select CSV, save your current sheet.

2. transfer to a holding directory on the Pg server the postgres user can access

3. in PostgreSQL:

   COPY mytable FROM '/path/to/csv/file' WITH CSV HEADER; -- must be superuser
   

But there are other ways to do this too. PostgreSQL is an amazingly programmable database. These include:

1. Write a module in pl/javaU, pl/perlU, or other untrusted language to access file, parse it, and manage the structure.

2. Use CSV and the fdw_file to access it as a pseudo-table

3. Use DBILink and DBD::Excel

4. Write your own foreign data wrapper for reading Excel files.

The possibilities are literally endless….