Search for content in message boards

GEDCOM to MS Access or Excel

Replies: 139

Re: GEDCOM to MS Access or Excel

Posted: 1315063152000
Classification: Query
Edited: 1315153762000
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
Raventhalas 1315063152000 
calrivethed 1341208251000 
cnewton1969 1341418172000 
calrivethed 1341422082000 
cnewton1969 1341442112000 
grizzmex 1352313406000 
cnewton1969 1352329787000 
gwwmjw 1406868251000 
dalej72 1341220531000 
kj_norway 1341377006000 
per page

Find a board about a specific topic