Import Excel File into PostgreSQL database

1. Create table in the database which you want to use to hold the content in the excel file using create table command. For simple you can create a table with exactly same field name as in the excel file.
2. delete the field names from the excel file if there is any.
3. Save the excel into CVS (Comma separated file) file.
4. use the copy command to transfer data from CVS file into database.
copy table_name from 'source_file_with_path' DELIMITERS ',' CSV;
for example,
copy student_19 from 'E://ftproot//Student_19.csv' DELIMITERS ',' CSV;