You may have to select from the child table multiple times though since the
records need to be merged so your select may have to look something like
select * from job, job_item as ji1, job_item as ji2 etc...
________________________________
From: Mark Bartnik <bartnikmark@hotmail.com>
To: Access VbaCentral <accessvbacentral@yahoogroups.com>
Sent: Wed, August 11, 2010 9:55:01 AM
Subject: RE: [Access VBA Central] De Normalizing a Parent Child Table in Export
Hello,
Create a query to include the columns in the same sequence as the Excel sheet.
Export the query to a CSV file or directly to Excel.
Regards,
Mark Bartnik
Marygrove College Alumni Association Board of Directors
586 306 4090 cell.
Marygrove College Alumni Assoctiation
To: AccessVBACentral@yahoogroups.com
From: jhundleyj@yahoo.com
Date: Wed, 11 Aug 2010 13:29:10 +0000
Subject: [Access VBA Central] De Normalizing a Parent Child Table in Export
I have a parent and child table setup JobDecriptions and JobDescriptions Items.
When I originally got the data it was in an Excel spreadsheet with columns for
Job Code and info ans then Task1 Task2 Task3 Task4 Task5 Ed1 Ed2 Ed3 Ed4 Ed5
LIC1 LIC2 LIC3 LIC4 LIC5 .
I was able to seperate the data into two tables one containing job code and
other information and then a second table listing each item (Task, Ed or Lic )
and its type individually linked to the parent table in a one to many
relationaship.
I have now been asked to recreate the original spreadsheet once or twice a year
- What is the best way to merge these two tables back like they were with the
all the child records being in the individual columns in excel.
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Nenhum comentário:
Postar um comentário