Search for content in message boards

GEDCOM to MS Access or Excel

Replies: 137

Re: GEDCOM to MS Access or Excel

Posted: 29 Mar 2008 12:40PM GMT
Classification: Query
Edited: 14 Jun 2016 1:38PM GMT
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 27 Mar 2008 10:44PM GMT 
Ted Pack 29 Mar 2008 6:40PM GMT 
cnewton1969 29 Mar 2008 7:53PM GMT 
Ted Pack 29 Mar 2008 8:24PM GMT 
robmoff 29 Oct 2009 10:08PM GMT 
jaws64 30 Oct 2009 12:48PM GMT 
cnewton1969 30 Oct 2009 6:21PM GMT 
cilurnum 6 Dec 2009 7:26PM GMT 
cnewton1969 6 Dec 2009 8:24PM GMT 
Lensmeister 2 Feb 2010 2:32PM GMT 
per page

Find a board about a specific topic