Previous Thread

8/16/2006 11:03:57 AM    Trying to import MS Access Cells to MS Excel.
I working on a project that uses single cell data for access to fill out 
 
single cells in Excel. Everytime I try and and add the "GET EXTERNAL DATA" to 
 
my Excel Template it wants to add the whole query rather then just single 
 
cell information. 
 
For example:   I have a job number and I want all the information for that 
 
job number to update my Excel Template Fields  such as PO Number, Customer, 
 
Deleviery Date? 
 
Does anyone have some input that they can give?



8/16/2006 8:18:27 PM    Re: Trying to import MS Access Cells to MS Excel.
Possibilities include: 
 
1) use Excel's Get External Data to import the query to a range on 
 
another worksheet. In each cell where you want one of the imported 
 
values to appear, put a formula referring to the appropriate cell in the 
 
imported range. 
 
2) Use a custom worksheet function that looks up and returns a single 
 
field value from the database (like an Excel version of DLookup()). If 
 
you search the newsgroups (e.g. at http://groups.google.com) for 
 
GetData34 
 
you'll find one 
 
On Wed, 16 Aug 2006 11:03:57 -0700, SchnidRoCK 
 
<SchnidRoCK@discussions.microsoft.com> wrote: 
 
-- 
 
John Nurick [Microsoft Access MVP] 
 
Please respond in the newgroup and not by email.