To all of Excel\Access gurus out there:
Trying to import about 15 excel sheets in to one access file to keep track of my inventory. In a way, all these sheets have user, licesnce #, PO number, purchased dates, key #s and other purchase related information. So by having it in an access file we want to be able to update many fields by just clicking one button. e.g. if machine name was changed, the new machine name has to get updated in all the other fields with old machine name in an automated way through access.