最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
读取Access数据库表名实例
时间:2022-06-30 10:24:08 编辑:袖梨 来源:一聚教程网
<%
strConn="DBQ="+server.mappath("kendylan.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set objConn=server.createobject("Adodb.connection")
objConn.open strConn
set rsSchema=objConn.openSchema(20)
rsSchema.movefirst
Do Until rsSchema.EOF
if rsSchema("TABLE_TYPE")="TABLE" then
response.write rsSchema("TABLE_NAME") & "
"
end if
rsSchema.movenext
Loop
set objConn=nothing
%>
strConn="DBQ="+server.mappath("kendylan.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set objConn=server.createobject("Adodb.connection")
objConn.open strConn
set rsSchema=objConn.openSchema(20)
rsSchema.movefirst
Do Until rsSchema.EOF
if rsSchema("TABLE_TYPE")="TABLE" then
response.write rsSchema("TABLE_NAME") & "
"
end if
rsSchema.movenext
Loop
set objConn=nothing
%>
相关文章
- 鬼谷八荒逆天改命会覆盖吗 06-14
- 妄想山海植物分布图 06-14
- 栖云异梦第三章攻略 06-14
- 奥比岛手游烟花盛会活动要怎样玩 06-14
- 米坛社区官网入口-米坛社区app网页版官网登录入口v2.29.28 06-14
- iwara官网入口下载-iwara下载免费官网入口v4.87.8.4.5 06-14