Text loading as numbers

[#1]

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.

[maxgro]

try with

text(field)

[alexandros17]

If you load a string made of digits it is recognized as number, write text(myField) to force as text

[MK_QSL]

Text(FieldName) as FieldName

[#5]

I tried text(myfield) but still showing numbers. Any solution please

[dirk_konings]

try to add a space after the value.

text(myfield) & ' ' as NewField

D.

[alexandros17]

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;

[MK_QSL]

can you upload your sample file please?

[#9]

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.

[#10]

Thanks. Still showing same numbers.