How do you create a table in SQL, using VB with ADO?

I have have ran it in ISQL_w and it creates the table fine, but when I run it in VB, it doesn't report an error, but it does not create the table?

This is what I have, what is not right?
The connection works, and RS is a recordset:

With cmd_Local
.activeconnection = gCN
'Build table
.CommandText = "CREATE TABLE #TempTable ( Field1 varchar(8), Field2 smallint)
Set rs_Local = .Execute
End With

Jason