Trying to import MS Access Cells to MS Excel.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top