Query an Access Database from within Excel

Article View: comp.databases.ms-access

Article #235

Back to comp.databases.ms-access Previous Next

#235

From: David
Date: Wed, 12 Jul 2000 00:00

16 lines
1588 bytes

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: <396c1ece.0@news1.mweb.co.za>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10d836,11caec9ef56a3674,start
X-Google-Attributes: gid10d836,public
X-Google-Thread: 1137ed,11caec9ef56a3674,start
X-Google-Attributes: gid1137ed,public
X-Google-Thread: 1142f6,11caec9ef56a3674,start
X-Google-Attributes: gid1142f6,public
X-Google-Thread: f8db2,11caec9ef56a3674,start
X-Google-Attributes: gidf8db2,public
X-Google-Thread: ff0ac,11caec9ef56a3674,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 11387c,11caec9ef56a3674,start
X-Google-Attributes: gid11387c,public
X-Google-Thread: 115bcb,11caec9ef56a3674,start
X-Google-Attributes: gid115bcb,public
From: "David" <habanero.burns@mweb.co.za>
Subject: Query an Access Database from within Excel
Date: 2000/07/12
Message-ID: <396c1ece.0@news1.mweb.co.za>
X-Deja-AN: 645373183
X-Trace: 12 Jul 2000 09:31:26 +0200, rdg-dial-196-30-236-46.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,microsoft.public.access.devtoolkits,microsoft.public.access.multiuser,microsoft.public.access.odbcclientsvr
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200