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

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

1. ASP实例代码，利用SQL语句动态创建Access表。 
3. 留作参考,对在线升级数据库有用处. 
5. 以下为引用的内容： 
7. <% 
8. nownowtime = now() 
9. tablename = cstr(year(nowtime))+"_"+cstr(second(nowtime)) 
10. response.write tablename 
11. db_path = "test.mdb" 
12. Set conn= Server.CreateObject("ADODB.Connection") 
13. connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath(db_path) 
14. conn.Open connstr 
15. Set rs = Server.CreateObject ("ADODB.Recordset") 
16. sql = "create table "& tablename &" (id integer primary key,name text,Birthday datetime)" 
17. rs.Open sql,conn,2,3 
18. %> 

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>