用sql語句動態的創建access表

    用sql語句動態的創建access表的代如下！  <%
 nowtime = now()
tablename = cstr(year(nowtime))+\_\+cstr(second(nowtime))
responsewrite tablename
db_path = \testmdb\
Set conn= ServerCreateObject(\ADODBConnection\)
connstr = \Provider=MicrosoftJetOLEDB;Data Source=\&ServerMapPath(db_path)
connOpen connstr
Set rs = ServerCreateObject (\ADODBRecordset\)
sql = \create table \& tablename &\ (id integer primary keyname textBirthday datetime)\
rsOpen sqlconn
%>
From:http://tw.wingwit.com/Article/program/net/201311/11594.html