URGENT: Help needed for Access!

[Guest]

I am new at MS Access but have been tasked to create a Database for my company

Background

7 subsidiaries have submitted their Excel spreadsheets with the following headings

Institution_Name Material_Group Product_Description Vendor_Name Amount_Pai

Problem

I need to be able to cross search all 7 spreadsheets utilizing either Institution Name, Material group etc

1). Should I integrate all 7 spreadsheets into ONE lengthy table? Can't do it in excel... too long. Don't know how to integrate the tables in Access

2). Or, can Access be used to cross search all 7 spreadsheets? If so, pls tell me how, thanx


Your help in this matter is greatly appreciated

Thank you and best regards

Mar

 

[John Nurick]

Answered in .externaldata. Please don't post the same message separately
to multiple groups.