ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How Do I program Excel to Source a Database (https://www.excelbanter.com/excel-programming/312301-how-do-i-program-excel-source-database.html)

Andrea Pickens

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?

Tom Ogilvy

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