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: [email protected] From: [email protected] 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: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
