Search for content in message boards

GEDCOM to MS Access or Excel

Replies: 111

Re: GEDCOM to MS Access or Excel

Posted: 3 Sep 2011 9:19AM GMT
Classification: Query
Edited: 4 Sep 2011 10:29AM GMT
I don't know if you found any information but none the less.

You can import your data in Access and Excel but the basic functions only allow importing text coded records. To do anything else more accurate, you need to create custom queries and macros in Access or Excel. The images can be re linked but you'll probably need to link them manually unless your GED file has those links. You can also create a macro which changes the links in your GED file prior to importing it.

The Access or Excel queries would need to read the GED contents and the macros could then format the links. It's not impossible to do but it involves work on your part.

The product owners don't expect people to move away form their products so they don't provide anything else but simple backup and import tools. The good news is that once you create your new database and setup all the macros and queries you can also include functionality to do full backups including any scans.

Please note though that Excel and Access are still limited and any good quality database managing softwares won't be free.

Hope this helps.
SubjectAuthorDate Posted
cnewton1969 29 Dec 2011 11:50AM GMT 
revjvw 29 Dec 2011 2:25PM GMT 
Raventhalas 3 Sep 2011 3:19PM GMT 
calrivethed 2 Jul 2012 5:50AM GMT 
cnewton1969 4 Jul 2012 4:09PM GMT 
calrivethed 4 Jul 2012 5:14PM GMT 
cnewton1969 4 Jul 2012 10:48PM GMT 
grizzmex 7 Nov 2012 6:36PM GMT 
cnewton1969 7 Nov 2012 11:09PM GMT 
gwwmjw 1 Aug 2014 4:44AM GMT 
per page

Find a board about a specific topic

  • Visit our other sites:

© 1997-2014 Ancestry.com | Corporate Information | New Privacy | New Terms and Conditions