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.
|