Article View: cn.bbs.comp.database
Article #353Re: ADO Open������
From: ��ϵ����*Shiyanʲôʱ�����*5������
Date: Fri, 06 Mar 2009 04:35
Date: Fri, 06 Mar 2009 04:35
35 lines
2309 bytes
2309 bytes
cn������֮��Ӧ���ȴ�ado����
���磺
Set cnn = New ADODB.Connection
cnn.Open "Provider=microsoft.jet.oledb.4.0;" _
& "Extended Properties=Excel 8.0;" _
& "Data Source=" & ThisWorkbook.FullName
�����Ҵ��Լ���һ����������������ģ��������cnn�����������cn����cn��֮��
���к����rs.open�ſ��У�����Գ���һ��
����cn.open�IJ���������һ�°�~
�� �� zxxia (����) �Ĵ������ᵽ: ��
Dim cn As New ADODB.Connection '����һ��Ado����
Dim rs As New ADODB.Recordset '����һ��Ado��¼��
Dim sql As String '����һ���ַ����
Set cn = CurrentProject.Connection '����cn���ڵ�ǰ����
sql = "SELECT * FROM [QPM AVG]" '���ַ�ֵ
rs.Open sql, cn, adOpenDynamic, adLockOptimistic, 1 '��һ����¼��������rs
�������ڵ��Ե�ʱ��ϵͳ˵��Open ��������һ������û�б�ָ���� ��ʲôԭ���أ�
��̴�����лл
--
--
[1;31mHebei
��������Զ��ů�ļ�
[0;1;5;36mqq����ϵ����[m
[1;33m��Ʒ����ӭ���� Tea ��
[m[1;37m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 59.78.26.99][m
Technical Details
Message-ID:
<4eh2Sd$bSb@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.byr.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,3a8cbc17eecf4c96,start X-Google-Attributes: gid101948,domainid0,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.byr.edu.cn!news.shec6.edu.cn!SJTU From: qqlover.bbs@bbs.sjtu.edu.cn (��ϵ����*Shiyanʲôʱ�����*5������) Newsgroups: cn.bbs.comp.database Subject: Re: ADO Open������ Date: 06 Mar 2009 04:35:08 GMT Organization: ��ˮ˼Դ Message-ID: <4eh2Sd$bSb@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1236313959.A Lines: 34