ADODB Append Field Data Type

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!!

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

VB Code:

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