Sumproduct in Excel Spreadsheet to read Access db table

[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]

Hi
no this is AFAIK not possible. But you may consider creating a speciifc
query in Acees directly