用ASP和SQL语句动态的创建Access表

asp实例代码，利用sql语句动态创建access表。

留作参考,对在线升级有用处.

<%
 nowtime = now()
tablename = cstr(year(nowtime))+"_"+cstr(second(nowtime))
response.write tablename 
db_path = "test.mdb"
set conn= server.createobject("adodb.connection")
connstr = "provider=microsoft.jet.oledb.4.0;data source="&server.mappath(db_path)
conn.open connstr
set rs = server.createobject ("adodb.recordset")
sql = "create table "& tablename &" (id integer primary key,name text,birthday datetime)"
rs.open sql,conn,2,3
%>