modifying Data type

[mask.sd]

I want to change data type of column i.e. from text to integer
in the mdb with there are some records in the mdb ?

Please can anybody suggest the solution for the same?
Thank U

 

[ruralguy via AccessMonster.com]

Play it safe! Make a backup and with the backup add a new integer field to
the table. Are you sure an integer is large enough to handle any data it
might hold. There is always Long. Anyway, then run an update query that
initializes the Integer field from the text field. Once you are satisfied
the the numeric field is properly initialized then then delete the text field
and rename the numeric field to the old text field name if you want.