用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
%>