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

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/AccessVBACentral/join
(Yahoo! ID required)

<*> To change settings via email:
AccessVBACentral-digest@yahoogroups.com
AccessVBACentral-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
AccessVBACentral-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/