Exporting file from Access to Lotus Approach

[awhitsel]

I am attempting to export a Microsoft Access table into a dbf file format so that it can be imported into an aplication written in Lotus Approach, however I am encountering the following error message: "Cannot define field more than once." with OK and Help buttons.

I looked at the field names and I don't see anything wrong with them.

Anybody out there know if I'm overlooking something?

Thanks.

 

[cbogz]

I have read the dbf files may not support long field names (longer than 10?), so if the field names are getting truncated on export, you may be running into trouble because of it.

I tested it on my system and tried to export a table I knew would create duplicate field names, and indeed, I ran into the same problem you did.

 

[awhitsel]

Thanks. Now I am coming up with another error message "Unexpected error from external databse driver (157)" with OK and Help buttons.

Is this error caused by the long field names or something else?

Thanks.