Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 11th 06, 09:58 AM posted to microsoft.public.excel.worksheet.functions
dan dan is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 866
Default Linking worksheet to Access Tables

How can I link a worksheet with an Access Query that combines information
from two of my tables in Access. I use Access to manage my tables and the
information changes daily. When I post the information on my department's
homepage I have to place it in an Excel worksheet. I would like for the
worksheet in Excel to change when ever changes are made to either table in
Access. There is also other worksheet in the workbook on the homepage, if
this matters.

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 worksheet retrieving data from Access [email protected] Links and Linking in Excel 1 May 8th 06 12:32 AM
Worksheet Linking problem MarkGG Excel Discussion (Misc queries) 6 October 28th 05 03:13 PM
Comparing a list to a Calendar worksheet. PatrickL Excel Worksheet Functions 0 August 25th 05 04:21 PM
MS Query cannot find tables in Access database Dennis Cheung Excel Discussion (Misc queries) 0 July 7th 05 04:17 PM
Worksheet linking Bed Excel Worksheet Functions 1 April 29th 05 03:08 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017