Article View: cn.bbs.comp.database
Article #9492Re: ��λ��access�е���ݱ����
From: ���֮��
Date: Tue, 29 Jul 2003 12:30
Date: Tue, 29 Jul 2003 12:30
17 lines
1556 bytes
1556 bytes
������һ����ASP��ȡaccess����Ĵ��룬��֪�����Ƿ�����
<%
strConn="DBQ="+server.mappath("data/xxx.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") & "<br>"
end if
rsSchema.movenext
Loop
set objConn=nothing
%>
--
[1;32m�� ��Դ:����ɽ��Ժ BBS http://bbs.qxntc.edu.cn [FROM: 61.234.55.3][m
Technical Details
Message-ID:
<47S4QG$ZKB@bbs.qxntc.edu.cn>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news-out.visi.com!petbe.visi.com!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news2.uestc.edu.cn!QXNTCShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB X-Google-Thread: 101948,c0b9e62322ffc3b2 X-Google-Attributes: gid101948,public X-Google-ArrivalTime: 2003-07-29 05:32:09 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news-out.visi.com!petbe.visi.com!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news2.uestc.edu.cn!QXNTC From: Windancer.bbs@bbs.qxntc.edu.cn (���֮��) Newsgroups: cn.bbs.comp.database Subject: Re: ��λ��access�е���ݱ���� Date: 29 Jul 2003 12:30:40 GMT Organization: ��ɽ��Ժ_BBS Message-ID: <47S4QG$ZKB@bbs.qxntc.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: Database/M.1059481840.A Lines: 17