The following is a Plus Edition article written by and copyright by Dick Eastman.
I often receive e-mails asking questions about converting genealogy databases. The questions usually are more or less like this example:
My organization has been entering data for a long time in a general-purpose database program, not a genealogy program. We use Microsoft Access (or FileMaker Pro or SQL or some other general-purpose database program or Excel spreadsheets). We have thousands of entries in our database. We now want to put this information on the Web (or on CD-ROM or in a book), and we want to use the report generation capabilities of the Brand X genealogy program. Can we convert our Access (or other) database to GEDCOM and import it into the genealogy program?
The quick answer is, “Yes, if you have enough time and money. However, you will undoubtedly find that it is not practical.”
Genealogy programs are generally written by very talented software developers who spend thousands of hours developing their programs. Tying relationships together, generating pedigree charts, generating Web pages, producing GEDCOM files, and other such tasks has consumed hundreds of hours of these talented programmers’ time. After they have written the software one time, they can sell copies of their programs again and again to customers for a rather low price. If they sell enough copies, they can generate a profit. By selling multiple copies of their work, they are able to keep prices low enough for the masses to afford it.
If a given software developer creates the various required software routines and then finds very few customers, the prices will be prohibitive. If we multiply the thousands of man-hours required by a reasonable hourly rate, the resulting charges would be thousands of dollars when few copies are sold.
Now let’s examine Microsoft Access, FileMaker Pro, Excel, and other generic, general-purpose database and spreadsheet programs.
The remainder of this article is for Plus Edition subscribers only and will remain in the Plus Edition subscribers’ web site for several weeks.
There are three different methods of viewing the full Plus Edition article:
1. If you have a Plus Edition user ID and password, you can read the full article right now at no additional charge in this web site’s Plus Edition at http://eogn.com/wp/?p=46042. This article will remain online for several weeks.
If you do not remember your Plus Edition user ID or password, you can retrieve them at http://www.eogn.com/wp/ and click on “Forgot password?”
2. If you do not have a Plus Edition subscription but would like to subscribe, you will be able to immediately read this article online. What sort of articles can you read in the Plus Edition? Click here to find out. For more information or to subscribe, goto https://blog.eogn.com/subscribe-to-the-plus-edition.
3. Non-subscribers may purchase this one article, without subscribing, for $2.00 US. You may purchase the article by clicking here. Payment can be made with VISA, MasterCard, American Express, Discover Card, or with PayPal’s safe and secure payment system. You can then either read the article on-screen or else download it to your computer and save it.