Re: Query an Access Database from within Excel (2nd post?)

Article View: comp.databases.ms-access

Article #238

Back to comp.databases.ms-access Previous Next

#238

From: dlowell
Date: Thu, 13 Jul 2000 00:00

38 lines
1895 bytes

David,

IN Excel help, do a search on on "Microsoft Query". This is an add-in
that will allow Excel to retrieve data from your database using SQL. You
will be able to define what range to put the data in, and even what
cells to use for criteria. Its very nice!

In article <396c1ece.0@news1.mweb.co.za>,
  "David" <habanero.burns@mweb.co.za> wrote:
> 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
>
>

--
<----------------------------->
        Daron S. Lowell
  daron.lowell@rocketmail.com
 http://members.xoom.com/Zarqy

Sent via Deja.com http://www.deja.com/
Before you buy.

Technical Details

Message-ID: <8kjcqt$jje$1@nnrp1.deja.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: ff0ac,11caec9ef56a3674
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 1137ed,11caec9ef56a3674
X-Google-Attributes: gid1137ed,public
X-Google-Thread: f8db2,11caec9ef56a3674
X-Google-Attributes: gidf8db2,public
From: dlowell <zarqy@my-deja.com>
Subject: Re: Query an Access Database from within Excel (2nd post?)
Date: 2000/07/13
Message-ID: <8kjcqt$jje$1@nnrp1.deja.com>
X-Deja-AN: 645745051
References: <396c1ece.0@news1.mweb.co.za>
X-Http-Proxy: 1.0 x60.deja.com:80 (Squid/1.1.22) for client 198.133.22.70
Organization: Deja.com - Before you buy.
X-Article-Creation-Date: Thu Jul 13 03:25:31 2000 GMT
X-MyDeja-Info: XMYDJUIDzarqy
Newsgroups: comp.databases.ms-access,dk.edb.database.ms-access,it.comp.database.access,microsoft.public.access.developers.toolkitode
X-Http-User-Agent: Mozilla/4.7 [en] (WinNT; U)

Reply to Parent Message