Table Converter: Foreign table load issues


Hi List,
I get the following message when trying to load an access database table in the table converter:

ODB0000156 - SQLDescribeCol: Index column name NumberOfSpotsThisPer not in the table INVOICETRANSACTIONS

I can load other tables in the access database, so the only thing I can think is that the field name in this table is too long (actual field name= NumberOfSpotsThisPeriod). It seems to have concatenated the name at 20 chars. I've had a look at the DD and the data item name can be over 20.
Does anyone know of a restriction in field names in the table converter or am i barking up the wrong tree?
John Crook

Visit, your free web-based communications center. Life on the Dot.