Can't Export Table, Keep Getting Error Message

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

Guest

I have a table to export but I keep getting the error message- 'Can't define
field more than once.', no matter what I do. This table was sent to me, data
was inputed into it through a form, and I can run queries, etc with out
problems.

All of the columns are 10 charactors or less and there are no duplicate
columns names.; there are no duplicate rows either. Only the information in
some of the cells are the same but each row is unique.

I created a select query of all the columns but still get the same error.
I've went to links in other tables and even tried in ArcCatalog and get the
same error; I even copy and pasted it.

I can export to Excel and txt formats but not dbase. I need to export this
to a dBase file so I can import into ArcMap, well I can use a txt format but
ideally I need dBase.

I'm stumped!?
 
Hi

Double check all columns are 10 chars or less - if any are over they will be
truncated to 10 chars and then may have the same name as an existing column
(or another that is truncated).

Make sure you are in design view when checking column names - not datasheet
view - as columns could be hidden.

Also, check for special characters. For example, spaces in a column name
will be converted to underscores so the following column names will be equal
and give the error you decribed:

[My Col 1]

[My Col_1]

If still having problems, if there aren't too many columns, try exporting
all but the first to see if you get the error.

Then all but the second...
Then all but the third...etc

You will then be able to pinpoint the offending column (or columns)

hth

Andy Hull
 
Back
Top