Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table in access database with column cameraname and this column contains character(text) adat. When I am loading this table the character data is loading as numbers. can anyone let me know please what is this strange behaviour.
Thanks.
try with
text(field)
If you load a string made of digits it is recognized as number, write text(myField) to force as text
Text(FieldName) as FieldName
I tried text(myfield) but still showing numbers. Any solution please
try to add a space after the value.
text(myfield) & ' ' as NewField
D.
Initially week is a number, executing this script it become a string (you see it in the left side of the column)
load year, text(week) as week;
select year, week from period;
can you upload your sample file please?
Like the same the numbers are showing on left of column. But I need names instaed of numbers, because in the database there are names. Any idea please.
Thanks. Still showing same numbers.