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
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers