Trying to import MS Access Cells to MS Excel.

S

SchnidRoCK

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?
 
J

John Nurick

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
 
Top