LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default Linking a table in Access to a table in Excel using MS Query

In MS Query I would like to connect a Table from Access with Vendor Names to a small table in Excel specifing one Vendor Name and thus filtering the results

When I try to add a new table in MS Query I only have an option to add tables from the access database...Is it possible to connect those two tables

Thank you for your help
Dian

 
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
Connection of Excel 07 pivot table to Access Query makes DB read o Chuck W[_2_] Excel Discussion (Misc queries) 0 October 9th 09 03:45 PM
HELP linking access table to excel greg Excel Worksheet Functions 3 July 30th 08 03:29 PM
Excel Pivot Table or Access Cross Tab Query Question greene2j Excel Discussion (Misc queries) 0 January 14th 08 01:49 AM
Linking parameter query from Access to pivot table in Excel ken1975 Excel Discussion (Misc queries) 2 June 20th 06 01:51 PM
Linking Large Access Table into Excel Steven M. Britton Links and Linking in Excel 1 December 30th 05 11:28 PM


All times are GMT +1. The time now is 11:59 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"