Excel to lookup Access Database

PeterP · #1 05-31-2009, 10:01 PM

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.

thhui · #2 06-11-2009, 12:33 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access database engine with Streets and Trips 2009	dreemsnake	Misc	3	05-26-2009 10:25 AM
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
MS ACCESS - Import from Excel problem	Gregory_in_Montauk	Office	6	05-06-2005 08:50 AM