Hi Craig,
"Can these be entered into access directly or will Access have to use the Excel sheet"
gee, that is a loaded question ... depends on how you read the data. Oh, you WILL have to read the Excel sheet to get the calculations -- or you could put the calculations into Access ... but Excel is sometimes easier in that respect so you will most likely want to read what Excel has calculated.