Linking

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
 
D

DDM

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
 
T

tjtjjtjt

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
 
Top