How to convert Text into Number - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

How to convert Text into Number

murali_jidigemurali_jidige Posts: 29Member
Hello
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

Murali

Comments

  • splansingsplansing Posts: 140Member
    If you are going to use a query to read the data from your old table into your new table, set up the two fields so that Val(OldField) is being assigned to your NewField. The Val() function will convert text data into numeric data. Just make sure you really have nothing but numeric data in your field, or you'll get some funky results.

    : Hello
    : 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
    :
    : Murali
    :

Sign In or Register to comment.