I have one problem. I have database in Access 1997 and one field as datatype Text. But in this field all values are Integers, Float values only. Now i designed a new database in Access 2000 and in this i took the above said text field aa a Numeric field. So i have to convert the text data(which are actually numbers)into Numeric datatype in 2000. Can anybody suggest me how to convert this text data into numeric data using VB or any other method.
Hope to get reply from somebody