Re: Query an Access Database from within Excel

Article View: comp.databases.ms-access

Article #239

Back to comp.databases.ms-access Previous Next

#239

From: Steven M Ginter
Date: Thu, 13 Jul 2000 00:00

25 lines
1988 bytes

On Wed, 12 Jul 2000 23:40:09 +0200, habanero.burns@mweb.co.za (David) 
spake thus:
>Thanks for the reply.
>
>I would appreciate it if you could maybe give an example of the code.
>
>I do a lot of database programming using DAO . e.g. database . recordset
>definitions etc. Hope this will not be do much of a difference

sub whatever()
dim thatDB as object
set thatdb = createobject("Access.Application")
with thatdb
	.DoSomething '(like opening your database)
	.DoSomethingElse '(like running a query or function)
	'close your database
end with
set thatdb = nothing
end sub
-- 
Steve G.
"From personal experience, I can attest that reading the 
documentation for Microsoft's ActiveX gains 1D4 Mythos 
Knowledge and incurs 1D6 SAN loss."
-Russell Wallace, rasfwr-j

Technical Details

Message-ID: <MPG.13d774fca792cf4f989cb6@news.buffalo.edu>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <396c1ece.0@news1.mweb.co.za> <396c6ef3.1011935@news.syspac.com> <396ce6dd.0@news1.mweb.co.za>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff0ac,11caec9ef56a3674
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 1137ed,11caec9ef56a3674
X-Google-Attributes: gid1137ed,public
X-Google-Thread: 10d836,11caec9ef56a3674
X-Google-Attributes: gid10d836,public
X-Google-Thread: 11387c,11caec9ef56a3674
X-Google-Attributes: gid11387c,public
X-Google-Thread: 115bcb,11caec9ef56a3674
X-Google-Attributes: gid115bcb,public
X-Google-Thread: f8db2,11caec9ef56a3674
X-Google-Attributes: gidf8db2,public
X-Google-Thread: 1142f6,11caec9ef56a3674
X-Google-Attributes: gid1142f6,public
From: Steven M Ginter <smginter@acsu.buffalo.edu>
Subject: Re: Query an Access Database from within Excel
Date: 2000/07/13
Message-ID: <MPG.13d774fca792cf4f989cb6@news.buffalo.edu>
X-Deja-AN: 645865963
References: <396c1ece.0@news1.mweb.co.za> <396c6ef3.1011935@news.syspac.com> <396ce6dd.0@news1.mweb.co.za>
Organization: University at Buffalo
Newsgroups: comp.databases.ms-access,dk.edb.database.ms-access,it.comp.database.access,microsoft.public.access.developers.toolkitode,microsoft.public.access.devtoolkits,microsoft.public.access.multiuser,microsoft.public.access.odbcclientsvr

Reply to Parent Message