i have created a new SQL server connection.odc this works ok all 4 colums appear ok except colum "A"
colum "A" has mixed content ie numbers with either letters before or after the number ie ac7, 7bc, ad567ce
if the cell is just a numeric value 1234 ect cell is filled if the number has a mixed content the cell is empty.
can any one suggest how to overcome this apparent fault, also i would like this to be refreshed either manually or on opening