changing data types

[Thai]

Is there a way to change data types of a field using ado/adox? I ahve tried and it failed, here is my code:

Dim cat As New ADOX.Catalog

cat.ActiveConnection = myCN  'myCN is already open

For X = 0 to cat.Tables("Table1").Columns.Count -1
  cat.Tables("Table1").Columns(X).Type = adLongVarWChar
Next

That doesn't work, it gives me an error. Is there a way to do this in code?

Thanks,
Thai