Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
John V
 
Posts: n/a
Default linking data in excel and access

I am trying to look up a reference value in a excel worksheet cell in an
access database to display, in excel, a value related to that reference.
i.e. enter a part number in a excel cell (reference). I want it to lookup
that part number in an access database query and to display the location of
the part in a cell on the excel worksheet

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
Transferring data from MS Access to MS Excel Joe Excel Discussion (Misc queries) 2 April 5th 06 06:24 PM
Linking Large Access Table into Excel Steven M. Britton Links and Linking in Excel 1 December 31st 05 12:28 AM
How to import data from a password protected Access DB into Excel. Agus Excel Discussion (Misc queries) 0 October 12th 05 05:42 PM
Send Excel data to Access through button julesferreira Excel Discussion (Misc queries) 1 June 17th 05 07:30 PM
Refreshing Access data in Excel Jimmy G Excel Discussion (Misc queries) 0 December 21st 04 04:53 PM


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