Search for content in message boards

GEDCOM to MS Access or Excel

Replies: 137

Re: GEDCOM to MS Access or Excel

Posted: 1206816029000
Classification: Query
Edited: 1465933091000
Usually we get the opposite question; someone has started to do genealogy with Excel and realizes, 1, 3 or 5 months, years or days into the project, that a genealogy program would be a better tool, so they want to transform a spreadsheet into a GEDCOM.

If you have a genealogy program with good reporting features, like Roots Magic (FTM will do it too), you can create a custom report with all of the fields you are interested in, then run it on selected people and "print" to a text file, which you can import into Excel.

For instance, "print" the name, birth date, birth place, marriage date, marriage place and spouse's name for everyone who has "Pennsylvania" in any fact place. I did that when I found a data base for Pennsylvania marriages. I deleted everyone whose marriage date & place I had, then looked for the rest on the data base.

Would that strategy work to solve your problem?
SubjectAuthorDate Posted
cnewton1969 1206657888000 
Ted Pack 1206816029000 
cnewton1969 1206820435000 
Ted Pack 1206822261000 
robmoff 1256854120000 
jaws64 1256906916000 
cnewton1969 1256926871000 
cilurnum 1260127572000 
cnewton1969 1260131091000 
Lensmeister 1265121170000 
per page

Find a board about a specific topic