ADODB Append Field Data Type

[cypang]

Guys, may I know how can I append the attribute type (data type, eg. from Integer to Text) of Microsoft Access 2003 database using ADODB from Visual Basic 6?

Thanks! Help is much appreciated!!

[Hack]

You aren't asking how to append, you are asking how to change the data type. Try something like

Dim sSQL As String
sSQL = "ALTER TABLE tablename MODIFY (columnname TO columname VARCHAR(XX))" 'where XX is the size you want the field to be
YourADOConnectionObjectName.Execute sSQL