熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> .NET編程 >> 正文

用sql語句動態的創建access表

2013-11-13 09:47:32  來源: .NET編程 
    用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
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.