Table Data Type

[IanT]

Hi

Is it possible by using code to change the Data Type in a table from text to number!

 

[Robert88]

Hi IanT

Here is an example;

Use ALTER COLUMN to change the data type of an existing field. You specify the field name, the new data type, and an optional size for Text and Binary fields. For example, the following statement changes the data type of a field in the Employees table called ZipCode (originally defined as Integer) to a 10-character Text field: 

ALTER TABLE Employees ALTER COLUMN ZipCode TEXT(10)

The above quoted from Pat Hartman (the GURU!!!) from the following link;

http://www.access-programmers.co.uk/forums/showthread.php?t=79395

Best of Luck

Robert88