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.
Microsoft Excel on the other hand is a spreadsheet program, it is usually used to display data and work out calculations in the form of tables and graphs, it also has a more integrated use of macros. So basically, Access stores data, Excel calculates and displays data.   ANS2:Access creates relational databases.
You cannot create a link to an Access database from within Excel. When you link to an Excel file, Access creates a new table, often referred to as a linked table. The table shows the data in the source worksheet or named range, but it doesn't actually store the data in the database.You cannot link Excel data to an existing table in the database.hen you link to an Excel file, Access creates a new table, often referred to as a linked table. The table shows the data in the source worksheet or named range, but it doesn't actually store the data in the database. You cannot link Excel data to an existing table in the database.