modifying Data type

M

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
 
A

Allen Browne

You can change the data type in design view.
Naturally you lose any non-numeric values.

If you want to do it programmatically:
strSql = "ALTER TABLE MyTable ALTER COLUMN MyTextField SHORT;"
DBEngine(0)(0).Execute strSql, dbFailOnError
 
Top