G Guest Feb 25, 2004 #1 Using VBA, how can I change the data type of a field from number to text. thanks for the hel Alex
A Allen Browne Feb 25, 2004 #2 Execute a DLL query statement like this: dbEngine(0)(0).Execute "ALTER TABLE MyTable ALTER COLUMN MyField TEXT(30);", dbFailOnError
Execute a DLL query statement like this: dbEngine(0)(0).Execute "ALTER TABLE MyTable ALTER COLUMN MyField TEXT(30);", dbFailOnError
B Bas Cost Budde Feb 25, 2004 #3 Allen said: Execute a DLL query statement like this: Click to expand... That is DDL, right?
