I have Excel tables that I have entered genealogical data into, but I am having trouble integrating them into an Access database (the Wizards aren't working for me). I know a little bit about Access and understand the basic ideas behind creating a database, but I'd like to know step-by-step how to create my genealogy database and if I'm missing anything or taking unnecessary steps.
For the names tables, my headings are WhoID [my primary key], Father, Mother, First, Middle, Last, Suffix, Sx, Gen, FNumber [family number], FFunction [parent or child], BMonth, BDay, BYear, BWhere, DMonth, DDay, DYear, DWhere, DCause, Buried, and Memo.
For the marriage tables, my headings are Marriage [my primary key], Husband, Wife, MMonth, MDay, MYear, MWhere, Memo.
The main goal is so I can cross-reference genealogical data I've been gathering over the decades. Any assistance you could provide would be greatly appreciated. Thanks!
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.