PostGIS Shapefile Loader Error 2.1 – How to Fix DBF File Cannot Be Opened

postgispostgresqlshapefile

The .shp, .dbf and the rest of files are fine, I open them in QGIS, AGOL with no problem. In fact, I've tried 3 different layers, and get always the same error.

Anyone can please help, as I really need to migrate my .shp's to postgis, and have no idea of why it's not able to open .dbf?

Postgres v9.3 x86
Postgis shapefile loader v2.1

Thanks a lot in advance!

PS I've tried changing the default character encoding from the default 'UTF-8' to 'ISO 8859-14' but same error.

Best Answer

I just faced the same problem. I solved it by changing the location of shapefile. It seemed a problem of too long file name. When I moved the files up in folder tree, it worked perfectly, using the plugin.