• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

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?
Cheers,
John Crook


















___________________________________________________________________________
Visit http://www.visto.com/info, your free web-based communications center.
Visto.com. Life on the Dot.
 
Top