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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05