Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jules
 
Posts: n/a
Default Sumproduct in Excel Spreadsheet to read Access db table

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
--
Tx
Jules
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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

"Jules" wrote:

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
--
Tx
Jules

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Convert Word Table to Excel Spreadsheet [email protected] Excel Discussion (Misc queries) 1 January 18th 05 11:57 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 01:37 AM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 06:47 AM
vlookup function in excel referencing an access table AJN Excel Worksheet Functions 1 November 7th 04 08:09 PM


All times are GMT +1. The time now is 11:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"