Linking

  • Thread starter Thread starter adn4n
  • Start date Start date
A

adn4n

Hi everyone, i have a sheet named: Employee Data, but i would like t
link this to Microsoft Access so that when the details of an employe
are entered in a form at Access, it is automatically inserted int
Excel too, i should be able to delete, edit and add details o
employees, and it should take into effect at Excel.

How do i go the right way with this? Thanx, regards
 
Adn4n, open your Access database and File > Get External Data > Link. Go
through the steps and, when you're done, you'll see the little Excel icon
with the arrow next to it among your tables. That creates a link, so
anything you do to the data in Access will carry over to Excel, and vice
versa.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
 
Have youlooked into the Data|Import External Data feature? Sounds like you could do a New Database Query and access the database that stores the information. Then, import the table in question. This will link the data in Excel to the data in the database, and you will be able to refresh the Excel Data either by using the External Data toolbar or by right-clicking on the Excel data and choosing refresh

tj
 
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

Need Help!! 2
Dependent list in excel to create validation 1
adding worksheets 1
Creating worksheets automatically 3
Excel Urgent help in Excel / Access Report 0
Wits end wrt automatic linking 3
Detailed worksheet value entered automatically in Summary workshee 2
How To Use Excel Manage Recruit Employees? 1

Back
Top