[AccessD] Possible small paid project

_______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________




Hi Kathryn.

Just want to clarify.  You want to load the Excel data in MS Access?  Or just link the ID from Excel to Access?
Or Using the ID in Access as a Key, Update all the additional data from Excel to Access using the ID?
Not 100% clear on what you are after here, but if it is what I am thinking it should be easy and painless to do.

Cheers
Darryl.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kathryn Bassett
Sent: Wednesday, 14 July 2010 2:26 PM
To: 'dbAdvisors (AccessD)'
Subject: [AccessD] Possible small paid project

I have an Excel spreadsheet with the following columns:

Person_ID	
LNAME	
FNAME	
SEX	
STREET	
CITY	
STATE	
ZIP	
COUNTRY	
Father_ID	
Mother_ID	
Spouse_ID	
BirthDate	
BirthPlace	
MarriageDate	
MarriagePlace	
DeathDate	
DeathPlace	
NOTES	
MEMO

I'm not concerned with turning date fields into proper dates because they
aren't important to the grand scheme of things. And there is some info in
some of the fields that don't fit the field descriptions. That's not
important either. What needs doing by someone with knowledge on how to do
it, is to link the ID's and make a report that will show all the person's
data including their father/mother/spouse NAME instead of ID number. There
are about 7800 records.

It comes from a very very old dos genealogy program that is not capable of
making a gedcom file
(gedcom: http://en.wikipedia.org/wiki/Gedcom)

I'm trying to help the lady preserve the data and she's not computer
literate. At this point, it probably won't go into another genealogy
program, I'll just make a pdf of the resulting report.

I think I can get her to authorize $100 to take care of this. So, does
anyone feel they can write a query and report to do what I need done? If so,
I'll let you know off-list the location of the Excel file once I have the
go-ahead from her for the money (unless you want to do it for free like I'm
doing).

BTW, I have Access2007 with which to open your mdb.


--
Kathryn Rhinehart Bassett (Pasadena CA)
"Genealogy is my bag" "GH is my soap"
kathryn at bassett.net
http://bassett.net   



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________________________________________________

The information transmitted in this message and its attachments (if any) is intended 
only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review, 
retransmission, dissemination or other use of, or taking of any action in reliance 
upon this information, by persons or entities other than the intended recipient is 
prohibited.

If you have received this in error, please contact the sender and delete this e-mail 
and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or distribute 
the information contained in this e-mail and any attached files, with the permission 
of the sender.

This message has been scanned for viruses.
_______________________________________________________________________________________