Changing Data type

[sxchopr]

can someone tell me how to change a data type of a table, using vb. I need to change it from a numeric field to a text field. The reason being when I import this table into another database this field attaches to another table whose data type cannot be changed. Any help would be apprieciated. Thanks

 

[glynch]

Look up table objects, field objects and their properties. The datatype is one of the field object's properties and you can update this from code. I don't have Access on this PC soI can't look up the specific syntax, but you should find some examples in the Help files.

Good Luck

 

[Tim K.]

Check this article at Change Field Type.