How can I change the table structure and get Value3 from a c(30) to say a c(6). The desire is that the data in that field would of be truncated. Any thoughts would help me greatly.

The code used to create the table is below:

        Dim cn1 As New ADODB.Connection
        Dim cm1 As New ADODB.Command
        cn1.Open "Driver=Microsoft Visual Foxpro Driver;UID=;SourceType=DBF;Deleted=YES;Null=NO;SourceDB=D:\"
        cm1.ActiveConnection = cn1
        cm1.CommandType = adCmdUnknown
        cm1.CommandText = "CREATE TABLE mytable.dbf (Value1 C(12),Value2 C(11),Value3 C(30))"
        cm1.Execute