My client said the tables come from Clarion. When I open one in hexedit I do see what appears to be duplicate column names.

See this:
http://www.maroisconsulting.com/stuff/hexedit.png

I have not used this tool before. It looks like column "PCD_POWER_C" appears twice.

How do I try to change the column name?

Thanks


>You're hacking the DBF header, and you'll see the field names in there as you page down. You have to eyeball it to see if you can find the duplicate, then change one of them. If there is no duplicate, then it is probably table or DBC corruption as Craig said. If this table is part of a DBC, I'm not sure what effect changing the field name will have. I've only done this on free tables.
>
>>Ok, I'm running it now. I've never used it before. How do you change a column name?
>>
>>
>>
>>>How was this table created? If the problem is because the first 10 characters of the field name are duplicated, you can use a hex editor to fix that. HexEdit.app is in the VFP Tools folder.
>>>
>>>>So is there anything I can do?
>>>>
>>>>
>>>>>- Table is corrupt.
>>>>>- If part of the DBC, the DBC is corrupt.
>>>>>
>>>>>>When I attempt to open a table, I'm getting the error "Duplicate field names."
>>>>>>
>>>>>>What's causing this and wat can I do about it?
>>>>>>
>>>>>>Thanks