[GIS] PostGIS Shapefile Import Manager error postgis I am trying to import .shp to PgAdmin III but is error because of "dbf file can not be opened" and I dont understand why. Best Answer I think this error happens: If the dbf is missing or corrupt (note it should have the same name as the .shp (but with .dbf extension). If the file is present and not obviously corrupt (Like it has more than 0 bytes) Try opening the .dbf file in LibreOffice spreadsheet or Microsoft Excel to verify it's readable. Also as noted by some others, probably would help to have a folder name with just ASCII characters. Related Solutions[GIS] Loading Shapefiles into PostGIS using shapefile import/export manager You are looking for PostGIS 2.0 Shapefile and DBF Loader Exporter, so access "C:\Program Files\PostgreSQL\9.3\bin\postgisgui\shp2pgsql-gui.exe" Fix Error Importing Shapefile into PostgreSQL Using shp2pgsql Are you sure you checked whole instruction including creation of new database and spatialy enabled it? You can't import to any of templates, so you have to create new database, connect to it and before import you have to execute query: CREATE EXTENSION postgis; Related Question[GIS] Error exporting shapefile from QGIS into PostGIS
Best Answer
I think this error happens:
Try opening the .dbf file in LibreOffice spreadsheet or Microsoft Excel to verify it's readable.
Also as noted by some others, probably would help to have a folder name with just ASCII characters.