Changing the data type of a field through VBA Code

[chummy via AccessMonster.com]

I have imported a table into Access using code, and I need to be able to
change the data type of one of the fields from text to hyperlink using code
(it cannot be done manually). I have been trying to figure out how this
works but have had no luck. Any help would be much appreciated.