Append Query: Change Datatyp Number to Text

[Lars]

Hi All,

I have a problem:

Append Query: Change Datatyp from Number to Text?
My input tabel field has the datatyp "Number". The table
where I will append this records has for this field the
datatyp Text. So how can I change the datatyp.

Thanks
Lars

 

[Allen Browne]

If you want to change the Text field in your table to a Number type before
you import, just open the table in design view and change it there.

If you want to store the number in the Text field, I would have expected
Access to do this, but you could wrap the expression in Str() if necessary,
e.g.:
INSERT INTO ...
SELECT Trim(Str([MyNumber])), ...