I am attempting to join a spreadsheet containing all the CIA Factbook Country Comparison Data (many columns) to the existing Natural Earth world countries shapefile. I followd the tutorial here, but a couple of things occurred:
1) Several of bits of data were changed to -2147483648
2) The imported field lengths all show as "0" in the properties.
I am not trained in GIS and I have never worked with databases. I am simply trying to combine this data and shapefile, so that my students will be able to graphically manipulate and analyze the information in a new Global Studies course.
I've tried taking the spreadsheet (from Excel) and putting it through Access and then exporting to a dbf file. I have set all the field lengths to 100 (and even tried 50), but I get a "field will not fit in record" error. I even tried truncating the column headings to 10 (thinking that might have been the problem, based on internet searches), but it didn't help.
As Per Comment:
Here is a link to a version of the spreadsheet with truncated headings.
Here is a picture of the corrupt data.
https:// docs . google . com/file/d/0BzHj6AzbbxcINy1jTGRPTDh1bFU/edit?usp=sharing