When it comes to transfer data from excel worksheet to PostgreSQL, the task is not that easy. I tried to export file to CSV but it doesn't work because there were some columns which were not containing the data!!! And even one problem exist, Column type. In Java using ResultSet I successfully fetched data from excel as ODBC database but in some column where it contains text in some rows while in some rows it contained numbers!! So Java 'getString(column)' method did not worked!! So finally I imported that excel file into MS-Access and it worked, and then from there I read that data and inserted into PostgreSQL. To fetch column from excel file as ODBC backend, following code will be useful. select * from [WorksheetName$] To fetch only some data select * from [WorksheetName$A7:F10] or select First_row_data from [WorksheetName$] or if your excel file contains data in all columns then you can export it as CSV file and then can use PostgreSQL's COPY command. e.g. C...