Knox County. UT Extension serves the citizens of Knox County with educational programs in the areas of Agriculture, Family and Consumer Sciences, Community Resource Development, and 4-H Youth Development.
Both Excel and Access are capable of doing a lot of things that the other can do. Both can store data. Both allow you to manipulate data. Access is primarily for lists of data, such as names and addresses, while Excel mainly deals with numbers.
Use Access data in Excel. 1  To link to Access data and get information, you'll need to select Tools-Add-ins and check AccessLinks Addin and MS Query Add-in. 2  Then, from anywhere on your worksheet, you can select Data-Get External Data: 3  This will start MS Query.  Then select the database you want to use: