Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-31-2009, 10:01 PM
PeterP PeterP is offline Excel to lookup Access Database Windows XP Excel to lookup Access Database Office 2003
Novice
Excel to lookup Access Database
 
Join Date: May 2009
Posts: 1
PeterP is on a distinguished road
Default Excel to lookup Access Database

I have an Excel spreadsheet with a column called Style No. I also have an Access database with the main table having Style No as the Primary Key.



I want to know how I can call up the record on the Access database from the Excel spreadsheet and how I can trigger this process?

Any help would be greatly appreciated.
Reply With Quote
  #2  
Old 06-11-2009, 12:33 PM
thhui thhui is offline Excel to lookup Access Database Windows 2K Excel to lookup Access Database Office XP
Novice
 
Join Date: Mar 2009
Posts: 6
thhui is on a distinguished road
Default

Download the Excel Addin - Access link
http://www.microsoft.com/downloads/d...displaylang=en
and it will show some additional menu item in your excel menu to have access link application.
Reply With Quote
Reply

Tags
access excel link

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel to lookup Access Database Access database engine with Streets and Trips 2009 dreemsnake Misc 3 05-26-2009 10:25 AM
Excel to lookup Access Database Should I uses Access or Excel? tinkertron Office 5 03-29-2009 08:30 PM
Excel or Access ? inferno Excel 0 10-03-2008 03:42 AM
Delete excel files by code in Access Barry Richardson Office 0 06-13-2005 06:26 AM
Excel to lookup Access Database MS ACCESS - Import from Excel problem Gregory_in_Montauk Office 6 05-06-2005 08:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:51 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft