Re: [LegacyUG] family information in MS Access database

[Allan Abrahamse]

It is easy to convert an Access table to an Excel spreadsheet. Just select 
the table (or query) you want to export and click File->Export. Use the 
drop-down at the bottom of the box to select the version of MS Excel you 
have, use the rest of the dialog box to name the file if you don't like the 
default, and select the directory to save it to, the click Export.

Personally I think it will be easier to type everything in. It's unlikely 
that your excel spreadsheet will translate easily into a gedcom.

----- Original Message ----- 
From: "Robert Carneal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 15, 2004 8:26 AM
Subject: RE: [LegacyUG] family information in MS Access database


IF you can convert the access file to an excel file without too much
trouble, I can tell you how to use Excel to obtain a Gedcom. Not totally
painless, but faster than typing them all in. Let me know if you wan to 
try
this.

Robert
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Paul
Maclauchlan
Sent: Monday, November 15, 2004 9:44 AM
To: Legacy User Group
Subject: [LegacyUG] family information in MS Access database
I recently received an MS Access database containing information on a few
hundred people.
Is there any way to format this information into a GEDCOM file, or some
other means that can be used to get the data into a Legacy family file?
If there isn't, I had better start typing!  Thanks for your help.
--
.../Paul Maclauchlan
Whizzo Chocolate Company, Oakville ON Canada
[EMAIL PROTECTED]       http://www.vex.net/~paulmacl
Books, CDs & DVDs!
http://www.amazon.ca/exec/obidos/redirect-home?site=amazon&tag=whizzopresent
-20
"Show a little faith, there's magic in the night"
Legacy User Group Etiquette guidelines can be found at:
http://www.LegacyFamilyTree.com/Etiquette.asp
To find past messages, please go to our searchable archives at:
http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/
To unsubscribe please visit:
http://www.legacyfamilytree.com/LegacyLists.asp
Legacy User Group Etiquette guidelines can be found at:
http://www.LegacyFamilyTree.com/Etiquette.asp
To find past messages, please go to our searchable archives at:
http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/
To unsubscribe please visit:
http://www.legacyfamilytree.com/LegacyLists.asp


Legacy User Group Etiquette guidelines can be found at:
http://www.LegacyFamilyTree.com/Etiquette.asp
To find past messages, please go to our searchable archives at:
http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/
To unsubscribe please visit:
http://www.legacyfamilytree.com/LegacyLists.asp