![]() |
How Do I program Excel to Source a Database
I have created forms in Excel, and I would like to
program specific cells so that when I type in a company's name Excel would automatically bring in all of the associated contact information and addresses. Or can I link excel to acess, so that I use these cells in Excel to interface with information stored in an Acess Database? |
How Do I program Excel to Source a Database
Data=Get External Data
You can set up a parameter query based on the value of a cell. -- Regards, Tom Ogilvy "Andrea Pickens" wrote in message ... I have created forms in Excel, and I would like to program specific cells so that when I type in a company's name Excel would automatically bring in all of the associated contact information and addresses. Or can I link excel to acess, so that I use these cells in Excel to interface with information stored in an Acess Database? |
All times are GMT +1. The time now is 07:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com