Stuart McLachlan
stuart at lexacorp.com.pg
Wed Jul 14 00:26:31 CDT 2010
Sounds like a couple of minutes to import the spreadsheet into Access, maybe 5 minutes to build the query to return the required info, and another 5 to build a procedure that will psuh the data back out into a text file in the desired format. If you want to send me the Excel file, I'll have a crack at it. Don't worry about payment, it's not worth the hassle messing around with international transfers. -- Stuart On 13 Jul 2010 at 22:11, Kathryn Bassett wrote: > Darryl Collins asked: > > Just want to clarify. You want to load the Excel data in MS Access? > > Or just link the ID from Excel to Access? > > Or Using the ID in Access as a Key, Update all the additional data from > > Excel to Access using the ID? > > Not 100% clear on what you are after here, but if it is what I am > > thinking it should be easy and painless to do. > > The end result would be a report that shows the following in alpha order: > > Bassett, Kathryn (LName, FName concatenated, then after name should be the > sex designation with () around it) > (next line contents of Street City State Zip Country, concatenated) > Father: John Doe (name found by looking up the number in the Father_ID field > in the Person_ID field, to get the name) > Mother: Jane Smith (same scenario) > Spouse: David Bassett (same scenario) > Born: (contents of BirthDate and BirthPlace fields, concatenated) > Married: (contents of MarriageDate and MarriagePlace fields, concatenated) > Died: (contents of DeathDate and DeathPlace fields, concatenated) > Notes: (contents) > Memo: (contents) > > Next record > > Next record > > Next record until done. > > So, however it's done doesn't matter to me as long as I can get the result > in a Word (or WordPerfect) file. From there, I'll add headers and other > things I'll want to add before making the pdf. > > > -- > Kathryn Rhinehart Bassett (Pasadena CA) > "Genealogy is my bag" "GH is my soap" > kathryn at bassett.net > http://bassett.net > > > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >