>Good One! The following code does work:
> Dim cn As New ADODB.Connection
> Dim cm As New ADODB.Command
> cn.Open "Driver=Microsoft Visual Foxpro Driver;UID=;SourceType=DBF;Deleted=YES;Null=NO;SourceDB=E:\"
> cm.ActiveConnection = cn
> cm.CommandType = adCmdUnknown
> cm.CommandText = "CREATE TABLE C:\TEST (TEST C(10))"
> cm.Execute
>
>The only watchout is that the command ignores the SourceDB setting and creates it in an upredicatable directory unless you specify the path like shown as C:\TEST. If you just specify CREATE TABLE TEST it will create the dbf in VB's current directory setting, not the SourceDB setting.
>
>
>>Joe,
>>
>>According to the docs for the VFP ODBC driver, you should be able to create tables by submitting a CREATE TABLE command. Look for the file drvvfp.hlp on your computer.
>>
>>-Mike
This works great!! I am still trying to get the other way to work too. Thank you everyone. Any addl info would be good to discuss and could help increase
participation.
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams