URGENT: Help needed for Access!

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_Paid


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.


Mark

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

On Mon, 17 May 2004 18:51:06 -0700, "AccessDoDo"
wrote:

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_Paid


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.


Mark

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.