TMG-L Archives

Archiver > TMG > 2002-10 > 1034819332


From: Lee Hoffman <>
Subject: Re: [TMG] Importing Data from Excel spreadsheet files
Date: Wed, 16 Oct 2002 21:48:52 -0400
References: <004401c2755d$07d800c0$020aa8c0@library>
In-Reply-To: <FPEDKEBBIJEAPMOIBIGFCEAGCOAA.research@nobis.net>


Research wrote:
>Does anyone have any suggestions on how to import data that is in an Excel
>file (or tab delimited Word file) into TMG 5.03? Is it possible to use
>GenBridge to do this?

No, because there is not a standard method of entering data into Excel (or
any other spreadsheet) or any word processor.

>I have a number of files of information that are Excel spread sheets and a
>few that are tab delimited word files. Is there a way I can import these
>into TMG 5.03? I could easily reformat or restructure these files. For
>example, placing cities and countries in separate columns or setting the
>sequence of columns differently.
>
>I am trying to avoid retype a large number of files that have quite a bit of
>data in them. I prefer to place these files in TMG, because of the power,
>flexibility and capability of TMG. Also this will easily allow me to merge
>files, once cleaned up with my TMG data files.

The only suggestion I have is that you create GEDCOM files from these
files. GEDCOM files are not hard to create although they would take some
time to do. Regrettably, my recommendation would be to bite the bullet
and just retype the data. In all likelihood, this would take only a little
longer than trying to create GEDCOM files.

A second option may be to contact Tech Support and ask if they can import
your files for you. I think they have in the past under certain
conditions. So maybe they can for you. Although you need to be aware that
they are in the process of finalize TMG v5 and are very busy, so your
request may take some time if they can do it at all.

Hope this helps -

Lee Hoffman/KY
TMG Tips: <http://www.tmgtips.com>;
My website: <http://www.tmgtips.com/lhoffman>;
A user of the best genealogy program, The Master Genealogist (TMG)

This thread: