ADO How to Create new table

[DGA15]

I have just started using ADO instead of DAO.
Using VB6 - SP5.
How can I create a new table in an existing database I am connected to?
For example Create table "NewTable" with 2 fields ( "Fld1", "Fld2&quot. Fld1 is string and Fld2 is double. Already connected to the database with myCnn.

Sample code and suggestions greatly appreciated.
Billg in hot California.

 

[prem2000]

hi,
u can do this

create table new(fld1 int,fld2 char(10))
i don't jnow whether u actually ,meant this.

 

[sunaj]

-----------------------------------------------------------
Dim con As ADODB.Connection

set con = New ADODB.Connection
con.Open "Your connection string"
con.Execute "CREATE TABLE TblMyTable (field type,[field type])"
-----------------------------------------------------------

Sunaj