Hi,

In the table tttxt010xxx , there is field called text which the text entered by the user. The type is text The problem when the text field is picked using ms access , it is shown as binary format. How to convert the field to text format in ms access.

regards,

George :confused:

attached is the screen shoot

Hi,
If you are using SQL Server 2000 sql statement (views or procedures) to pick the data from the text table, then you could use
Cast(t_text as Char(240)) (length of the datatype depends on how many characters you have in the t_text field in baan)
or
Cast(t_text as Varchar(240)) (truncates the extra space)
...to convert the field to readable datatype.

Alternatively you could use "Convert" option also instead of "Cast"..
Syntax: Convert(Char(240), t_text)

In Access Queries i guess CStr(t_text) might just do the job for you..

sk