cannot define field more than once

[wsproperties]

I am trying to export an access table to a .dbf file. It is a large file (89000) records. None of the field names are the same but I am getting an error, Cannot define field more than once (error 3191). In looking at the field names none of them are the same name, although some of the names are similar (ie school 1, school 2)

This is the first time this happened. Any thoughts here?

 

[Remou]

Try getting rid of the spaces in the field names.

 

[fneily]

By the way, if you have fields such as School_1, School_2, etc., your table isn't normalized. Violates the first normal form - duplicate field names.(Drop the number, duplicates)
You may want to ask whoever designed your database to redesign correctly.

 

[dhookom]

There is a limit to the number of characters in dbf field/column names. I expect you are truncating some field names which is causing the duplicates.

Duane
Hook'D on Access
MS Access MVP