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
|
|||
|
|||
design help needed
Need some guidance on a task I am looking in to. I hava an excel spreadsheet
that exports some data in to a access db table. There are 6 fields in the table (ID, MName, Role, Proj, Joined and Group. What I am trying to figure out is a way to clean up the table. In each field there are duplicates. I was thinking that I could create a separate table for the MNames and Proj fields. Then replacing the data with the key id from the new fields. Does this sound like I'm going in the right direction. Thanks Bob |
#2
|
|||
|
|||
design help needed
Bobbo,
Well, we know what you have but not what you are doing. In order to determine a table set-up it would help to know what you are trying to track and why you are importing it to Access. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Bobbo" wrote in message ... Need some guidance on a task I am looking in to. I hava an excel spreadsheet that exports some data in to a access db table. There are 6 fields in the table (ID, MName, Role, Proj, Joined and Group. What I am trying to figure out is a way to clean up the table. In each field there are duplicates. I was thinking that I could create a separate table for the MNames and Proj fields. Then replacing the data with the key id from the new fields. Does this sound like I'm going in the right direction. Thanks Bob |
#3
|
|||
|
|||
design help needed
Hi Bob,
Without knowing what exactly is the data in the fields, it seems you need separate tables for Role, and Group also. Then you need a junction table that records each MName on each project. The junction table would look like: TblProjectMName TblProjMNameID ProjectID MNameID Steve "Bobbo" wrote in message ... Need some guidance on a task I am looking in to. I hava an excel spreadsheet that exports some data in to a access db table. There are 6 fields in the table (ID, MName, Role, Proj, Joined and Group. What I am trying to figure out is a way to clean up the table. In each field there are duplicates. I was thinking that I could create a separate table for the MNames and Proj fields. Then replacing the data with the key id from the new fields. Does this sound like I'm going in the right direction. Thanks Bob |
Thread Tools | |
Display Modes | |
|
|