Hi. I created a table with a text field by mistake. Only numeric data has been entered in this field but formatted for text. Worked great until I need to link it to a table with a numeric key. Easy fix is to create a numeric field and copy text data into the new field in each record in numeric format since there are now thousands of records.
Is there some way to convert text data to numeric and import into that new field? Any suggestions would be great as I don't want to manually tweak each record.