How Do I program Excel to Source a Database

  • Thread starter Thread starter Andrea Pickens
  • Start date Start date
A

Andrea Pickens

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?
 
Data=>Get External Data

You can set up a parameter query based on the value of a cell.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting from excel to acess database 1
Using data from cells in a Query to a MS Access Database 2
Running an Access function (with parameters) from Excel 6
How do make it a connection of Access Database from Excel? 2
find and scroll to cell string value in Excel 2
How to read index value and selected text of dropdown excel in C# 1
automatically copy information to different sheet if certain condi 6
Moving from Excel to Visual Studio 3

Back
Top