Convert Number Field to Text through code

[aqif]

Hi,

Is there anyway to Convert a field with Number data type to Text. In my DB the user imports a table and everytime they have to change data type of one field to Text to continue with further process. Any way to put code which runs after import and changes the data type

Cheers!
Aqif

 

[Mile-O]

Use the CStr() function.

 

[aqif]

Change at Table Level

Hi

Thanks for the reply but I am interested in changing at Table level because the value needs to updated back to table level so conversion will not help. Any ideas

Cheers!
Aqif

 

[Mile-O]

Use an update query to convert the table data with the CStr() function.