>Is it possible to create tables on the server database from Visual FoxPro.
>
>If possible, please give me a hint !
Benn,
It is possible - you can create both temporary or permanent tables. Simply issue the CREATE TABLE command along a connection:
lnHandle = SQLCONNECT( 'MyConn', 'sa', 'password')
lnResult = SQLEXEC( lnHandle, 'CREATE TABLE MyTable (....)')
If you want a temporary file (one that gets automatically deleted when the connection is lost), add a # to the fornt of the name of the table
HTH
regards
Ian