>Hi Alex,
>
>Thanks for your interest.
>
>"Doesn't "Create Table" work for you?"
>
>For some reason it doesn't. Maybe I am getting it all wrong, not using the right commands.
>
>Do you know somewhere I can find more info about this?
>
>Thanks again.
>
>Kind Regards,
>Tarran Walker
>tarran.wlaker@reliez.com.au

Tarran,
I think you mean from ASP. This worked for me :

&lt%
cCacheDir=server.mappath ("data")
cDestDB="\testdata.dbc"
Set oConn = CreateObject("ADODB.Connection")
With oConn
  .ConnectionString = "Provider=VFPOLEDB.1;Data Source=" & cCacheDir & cDestDB
  .CursorLocation = 2 ' adUseServer
  .Mode = 16 ' adModeShareDenyNone
  .Open
  .Execute("Create Table c:\myPath\testtable free (f1 c(10))")
  .Execute("Insert Into c:\myPath\testtable (f1) values ('hello')")
End With
%>

Cetin