import 1NF to 2NF db

carlchapman

Registered User.
Local time
Today, 11:05
Joined
Jul 25, 2006
Messages
29
Hello,

I am not sure if this topic has been coverd in access-programmers forum but I'll ask any way.

I have thousands of records stored in excel (1NF). I have a access db to improve the need to have so many records duplicated.

Is their a way, via an action query (if so what one - update, append, cross tab etc) or another method to import the records and put them into related table.

For example, the current 1NF record columns are as follows >

typeOrg cntPre cntFor cntInt cntSur jobTitId cntPMC cntLand cntMobile cntFax cntEmail cntBC cntAcc cntConf cntLes cntTB cntTR cntBanq cntMisc cntNotes Chase orgName orgAddr orgAddr2 orgCity orgCounty orgPoCode orgLandline orgFax orgEmail orgURL clientOf appVenue appD8 appType scrName orgNotes

In my DB i have seperated the above into many table.

Here is a list of new tables with colums >

Table Contact -

cntID orgID cntPre cntFor cntInt cntSur jobTitId cntPMC cntLand cntMobile cntFax cntEmail cntBC cntAcc cntConf cntLes cntTB cntTR cntBanq cntMisc cntNotes scrName

Table Organisation -

orgID typeOrg orgName orgAddr orgAddr2 orgCity orgCounty orgPoCode orgLandline orgFax orgEmail orgURL clientOf orgNotes

Table Appointments -

AppID cntID appVenue appD8 appType


Of course as organisation is the parent table, their is no problem doing a simple cut and paste, but i can work out how to put related records in a related table. Can you help?
 
If your data is fully clean (ie the repeated data is spelled and formatted identically in your data), then I would insert columns for orgID, AppID and cntID and allocate these as efficiently as you can.

Import the whole table into Access. Use append queries to add these to your new tables, using orgID, AppID and cntID as autonumber primary keys. The duplicated records will be rejected when you append the data.
 

Users who are viewing this thread

Back
Top Bottom