If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
URGENT: Help needed for Access!
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. |
Thread Tools | |
Display Modes | |
|
|