Relative Content

Tag Archive for exceldatabasepostgresqlimportnonetype

import Excel data with empty cells

I downloaded all the data of the World Bank and now I have almost 100 excel files with one million rows and I wanted to save all these excel files together in one postgresql file. The lines of these files are the names of the series and the columns are the years. For some series, you don’t have data in some years and the cell is empty. When I select the column type as an integer, I get an error for empty cells.