Search for content in message boards

GEDCOM to MS Access or Excel

Replies: 137

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 7:39PM GMT 
vítor carvalh... 16 Feb 2013 3:12PM GMT 
cnewton1969 17 Feb 2013 12:29AM GMT 
vítor carvalh... 17 Feb 2013 12:58AM GMT 
cnewton1969 17 Feb 2013 1:43AM GMT 
revjvw 29 Dec 2011 11:35AM GMT 
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 
per page

Find a board about a specific topic