New answers tagged dbf
You should just be able to use the "Add vector layer..." menu item to open the DBF file. It will show up as a table layer in the layers panel, and you can refer to it in the table join settings of another layer.
I think the easiest way is to open the DBF file in a Spreadsheet software (e.g., LibreOffice Calc or Excel), export it to CSV, and open it in QGIS using the Add Delimited Text Layer tool (find it in Layer-->Add Layer-->). Being there, you can select fields for longitude (X field) and latitude (Y field). Once points are loaded into QGIS, right click ...
.dbf files do have a size limit, but it isn't necessarily the number of rows. It's a disk size limit of 2GB. If you have a lot of attributes, the 5,000,000 rows could make the .dbf quite large. Perhaps you might want to remove some unnecessary attributes. Or split the file into parts. Alternatively, try looking at other file formats.
If it's Excel's usability you're after (extended search and replace, repeat previous values, fill, ...) and you can change the default storage format: use personal-gdb instead of shapefiles. Then you can just open the .mdb in Access and edit there or push/pull from .xls as needed. Remember it's important to keep the ObjectID or FID intact, so no adding or ...
Top 50 recent answers are included