Re: Query an Access Database from within Excel

Article View: comp.databases.ms-access

Article #236

Back to comp.databases.ms-access Previous Next

#236

From: Tom van Stiphout
Date: Wed, 12 Jul 2000 00:00

36 lines
2177 bytes

On Wed, 12 Jul 2000 09:26:35 +0200, "David"
<habanero.burns@mweb.co.za> wrote:

Hi Mr. Habanero  (cool name :-)

I would think you could use Automation to do this: set a reference to
Access, then create an object of type Access.Application. At that
point, the whole Access object model is available. I believe this will
allow you to run a query or a public function in a module.

I've typically gone the other way: the code in Access and Excel is
just a dumb report writer. This works, but formatting cells is
surprisingly slow.

-Tom.

>Hi All
>
> How do I write a function within Excel that will dsum an access database
> table (based on certain criteria  from within the Excel procedure). In
> essence I would like to create a report writer within Excel that the user
> can use to write reports based on data within an access table.
>
> Thanks for all your help
>
>
>
>
>
>
>--
>DME
>
>
>

Technical Details

Message-ID: <396c6ef3.1011935@news.syspac.com>

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

References: <396c1ece.0@news1.mweb.co.za>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11387c,11caec9ef56a3674
X-Google-Attributes: gid11387c,public
X-Google-Thread: 10d836,11caec9ef56a3674
X-Google-Attributes: gid10d836,public
X-Google-Thread: 1137ed,11caec9ef56a3674
X-Google-Attributes: gid1137ed,public
X-Google-Thread: f8db2,11caec9ef56a3674
X-Google-Attributes: gidf8db2,public
X-Google-Thread: 115bcb,11caec9ef56a3674
X-Google-Attributes: gid115bcb,public
X-Google-Thread: ff0ac,11caec9ef56a3674
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 1142f6,11caec9ef56a3674
X-Google-Attributes: gid1142f6,public
From: tomvs@syspac.com (Tom van Stiphout)
Subject: Re: Query an Access Database from within Excel
Date: 2000/07/12
Message-ID: <396c6ef3.1011935@news.syspac.com>
X-Deja-AN: 645462937
References: <396c1ece.0@news1.mweb.co.za>
X-Trace: news.randori.com 963407731 204.181.58.158 (Wed, 12 Jul 2000 06:15:31 PDT)
Organization: Mach 2 Systems, Inc.
NNTP-Posting-Date: Wed, 12 Jul 2000 06:15:31 PDT
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