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?
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?