1
adocnCase为你的ADOCONNECTION连接
Ssql="Create Table Users(ID int IDEntity(1,1) not Null Primary Key,UserName Varchar(20) not Null,Pwd Varchar(20) Null,Purview TinyInt default 0)"
or
Ssql="select * into newtable from oldtable where 1=2"
adocnCase.Execute(ssql)
2
Ssql="Select 1 from sysobjects Where Name='yourtable' and xtype='u'"
rst.open sql
if rst.eof then
msgbox "不在"
else
msgbox "在"
end if