Exporting data error: cannot define field more than once

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to export data from an Access database into a DBF so I can join it
with the data from a parcel shapefile. While I've done this several times
with no problem, one file gives me the error "cannot define field more than
once" when I try to export. I have no idea what this means.
 
If I remember correctly, the maximum length of a field name in dBase is
considerably shorter than it is in Access. If your field names are too long,
they'll get truncated. So if you have two fields named
'MyLongFieldNameNumber1' and 'MyLongFieldNameNumber2' in your Access
database, they may both become 'MyLongFi' when attempting to export to
dBase.
 
That was the problem. I was looking for duplicate field names, but didn't
think of the names being truncated in the export.

Thanks.
 
Back
Top