Database - Stopped reading some of the data sources Seguir

0
Avatar
Robert Mcadam

The last time this happened a tech support person had to deleted a file in the innerworkings of Bartender and put a new file in its place. Only reads numbers, nothing with Letters attached but column saved as text.

1 comentarios

0
Avatar
Pete Thane
Acciones de comentarios Permalink

I have seen this with Excel files previously where the data in the first few records of the column is numeric only whilst later records include letters or a combination of them. This is actually the ODBC driver that creates the link between Office/Excel and other programs like BarTender. The ODBC ignores that the field is set to text in the spreadsheet but juts looks at the first lines of data and decides what it is itself. 

The only way round this is to make sure the first record includes alpha characters in all the columns that need it, either by moving a record of adding a dummy record say with the word dummy or test as the values of the appropriate fields

Iniciar sesión para dejar un comentario.