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.
When you link to an Excel worksheet or a named range, Access creates a new table that is linked to the Excel data. If you want to add, edit, or delete data, you make the changes in Excel, and refresh (or requery) the data in the Access table. However, you cannot edit the contents of the table in Access. With your data linked to Excel, you can now create reports, queries, and read-only forms in Access.