Duplicate fields on a DBF file
-
hello! I'm creating an application that reads a DBF exported from a ARCview 3. I was able to run a query using a VisualFoxpro provider. The problem was, there are times when the exported DBF files contain duplicate fields, then an error occurs. I can't connect to the same DBf using MS ACCESS, is there a way to access tne tables in a low-level manner, say to be able to rename the fileds. My idea is to identify the fields via index since I can't aidentify them by their names and attach an incremental values to the name of the fields. um.. anybody know how to do this. :confused:
U Xux
-
hello! I'm creating an application that reads a DBF exported from a ARCview 3. I was able to run a query using a VisualFoxpro provider. The problem was, there are times when the exported DBF files contain duplicate fields, then an error occurs. I can't connect to the same DBf using MS ACCESS, is there a way to access tne tables in a low-level manner, say to be able to rename the fileds. My idea is to identify the fields via index since I can't aidentify them by their names and attach an incremental values to the name of the fields. um.. anybody know how to do this. :confused:
U Xux
Hi, first of all those DBF files are corrupted. It's not within the spefications of the format although I know that there are several ways to create such files. The only way I found to read such files was very lowlevel. Have a look here[^] or here[^]. Those sites describe the whole format of DBF files. Given this information you can either read the data yourself or just change the columns names so that each one has a unique name. Robert
-
Hi, first of all those DBF files are corrupted. It's not within the spefications of the format although I know that there are several ways to create such files. The only way I found to read such files was very lowlevel. Have a look here[^] or here[^]. Those sites describe the whole format of DBF files. Given this information you can either read the data yourself or just change the columns names so that each one has a unique name. Robert
exactly what I needed.! I appended a number series to the fieldnames. pretty dissapointed by the limited size of the fields. SO I had to truncate some of the letters. After that I was able to connect to it Using the VIsualFOxfrom Oledbprovide - it works ! Thank you.: -D
U Xux