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

I didn't tried it but can the "ALTER TABLE" do the job?