Changing Data Type

[aziz rasul]

I have inherited a table where the data type is binary in some cases and I want to change these to Numerical. When I do this in design, I get a message which says I can't do that. I have something like 200,000 records.

If I try to export as Text file I get Invalid Argument message coming up. Can anyone help?

 

[Liv Manto]

Can you just another number field and update it?

If binary value = blah, then update the number to blah.

 

[aziz rasul]

I didn't think of that. Thanks.