Change Data Type in Code

[Alex]

Using VBA, how can I change the data type of a field from number to text.

thanks for the hel

Alex

 

[Allen Browne]

Execute a DLL query statement like this:

dbEngine(0)(0).Execute "ALTER TABLE MyTable ALTER COLUMN MyField TEXT(30);",
dbFailOnError

 

[Bas Cost Budde]

Execute a DLL query statement like this:

That is DDL, right?