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

Article View: comp.databases.ms-access

Article #240

Back to comp.databases.ms-access Previous Next

#240

From: David
Date: Sat, 15 Jul 2000 00:00

49 lines
2051 bytes

great stuff thanks

David



--
DME

dlowell <zarqy@my-deja.com> wrote in message
news:8kjcqt$jje$1@nnrp1.deja.com...
> 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: <39708286.0@news1.mweb.co.za>

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

References: <396c1ece.0@news1.mweb.co.za> <8kjcqt$jje$1@nnrp1.deja.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1137ed,11caec9ef56a3674
X-Google-Attributes: gid1137ed,public
X-Google-Thread: ff0ac,11caec9ef56a3674
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 11387c,11caec9ef56a3674
X-Google-Attributes: gid11387c,public
X-Google-Thread: f8db2,11caec9ef56a3674
X-Google-Attributes: gidf8db2,public
From: "David" <habanero.burns@mweb.co.za>
Subject: Re: Query an Access Database from within Excel (2nd post?)
Date: 2000/07/15
Message-ID: <39708286.0@news1.mweb.co.za>
X-Deja-AN: 646707753
References: <396c1ece.0@news1.mweb.co.za> <8kjcqt$jje$1@nnrp1.deja.com>
X-Trace: 15 Jul 2000 17:25:58 +0200, rdg-dial-196-30-237-60.mweb.co.za
X-MSMail-Priority: Normal
X-Priority: 3
Newsgroups: comp.databases.ms-access,dk.edb.database.ms-access,it.comp.database.access,microsoft.public.access.developers.toolkitode
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200

Reply to Parent Message