Thanks that worked great.

Charles


>Hi Chuck ---
>
>Get your connection handle with SQLCONNECT and then:
>
>=SQLEXEC(nConnectionNum,"CREATE TABLE database..tablename (name CHAR(30), amount float)")
>
>Note that the datatypes are different in SQL-Server.
>
>
>>I can get connected to the server and create a database and select it.
>>How can I a create a table in the database? Any syntax would help.
>>
>>Charles