Sumproduct in Excel Spreadsheet to read Access db

[Guest]

Hi

I have an Excel spreadsheet that I currently export my access db to that
uses SUMPRODUCT. Is it possible to get the SUMPRODUCT formula to read the
access db without exporting the data. If not how do I set up an option on the
switchboard to export the data to the excel spreadsheet. This will need to
only export the data since the last time it was exported - ie only that which
has been edited or updated or can this only be done for the whole database ie
I would have to clear the spreadsheet before exporting the data?

Tx

 

[Guest]

There are a two ways that I know of to do this.

The first one:
When useing the Reports Wizard choose to do a summary report. This can be
found after you have choosen what fields to use. It may take a few botchs to
get it right. Probably no more than 20 min of your time.

The Second Option:
Unfortunitly this gets kinda comlicated so I recommend that you look to this
option as something in the future to research.

In an unbound control:
=DCount("*",Table","[SomeField] = SomeCriteria")

The best place to try and find this info is in the VBA Help "DCount"

 

[Jamie Collins]

I have an Excel spreadsheet that I currently export my access db to that
uses SUMPRODUCT. Is it possible to get the SUMPRODUCT formula to read the
access db without exporting the data.

Take a look at the functions in Excel's odbc add-in e.g. SQL.REQUEST.

You may need to download it from MSDN:

http://www.microsoft.com/downloads/...67-13a0-4895-9942-5b177846ab8a&DisplayLang=en



Jamie.

--