LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 97
Default how can excell extract data from Access (hot line?)

In excell worksheet there is a cell named: Total Sales which requires data
from Access sales data sales which has the report/form if we run can produce
the total YTD Sales.

My question is how can we link this excell cell to the access total YTD
sales. We know in access can only produce report if we run it, while
we(Budget control Dept) want the data be avaialbe any time. Because Budget
Contorl dept needs their excell worksheet be uptodate anytime (Hotline) We
are using network for this purpose.

We appreciate your idea/help

Frank
 
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
How do I extract the address from a hyperlink in excell ? SMcLarenOr Excel Discussion (Misc queries) 0 April 26th 06 10:18 PM
In Excell-2000, database how do you extract unique records bgpereira Excel Worksheet Functions 5 December 24th 05 06:47 AM
Data extract from access query TrevorM Excel Discussion (Misc queries) 4 September 23rd 05 09:29 AM
How do I remove repeating line in Excell - Top line on each page.. keepon Excel Worksheet Functions 1 March 23rd 05 11:26 PM
Need help! - Trying to use MS Query in Excel to extract MS Access xx Excel Discussion (Misc queries) 0 February 4th 05 04:11 PM


All times are GMT +1. The time now is 05:30 PM.

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

About Us

"It's about Microsoft Excel"