Exporting data error: cannot define field more than once

M

markd

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.
 
B

Brendan Reynolds

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.
 
M

markd

That was the problem. I was looking for duplicate field names, but didn't
think of the names being truncated in the export.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top