johncrook75
Member
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?
Cheers,
John Crook
___________________________________________________________________________
Visit http://www.visto.com/info, your free web-based communications center.
Visto.com. Life on the Dot.
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?
Cheers,
John Crook
___________________________________________________________________________
Visit http://www.visto.com/info, your free web-based communications center.
Visto.com. Life on the Dot.
