Prev: Option buttons for subform viewing
Next: Relationship Help
From: Bobbo on 22 Dec 2009 15:44
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
From: Gina Whipp on 22 Dec 2009 16:02
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" <Bobbo(a)discussions.microsoft.com> wrote in message
news:E086F689-3A8A-459E-AF86-957F8B0F4DA7(a)microsoft.com...
> 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


From: Steve on 22 Dec 2009 17:41
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
santus(a)penn.com


"Bobbo" <Bobbo(a)discussions.microsoft.com> wrote in message
news:E086F689-3A8A-459E-AF86-957F8B0F4DA7(a)microsoft.com...
> 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


 | 
Pages: 1
Prev: Option buttons for subform viewing
Next: Relationship Help