How to split an excel sheet with all data into a one-to-many relationship? (1 Viewer)

kawai6rr

Registered User.
Local time
Today, 08:25
Joined
Aug 26, 2009
Messages
21
I’m trying to create a database to track melanomas. I need to split the excel sheet into a one-to-many relationship because one member can have multiple melanomas.

Tables
memberInfo ß---- one-to-many ------à melenama

meberInfo structure
Name Type Size
id Long Integer4
MRN Long Integer4
Last Text 50
First Text 50
MI Text 50
Sex Text 50
DOB Date/Time 8

Melanoma structure
Name Type Size
melanomaID Long Integer 4
id Long Integer4
MRN Long Integer 4
ProvLast Text 255
Prov FirstText 255
ProvMI Text 255
Degree Text 255
PCP FirstText 255
PCPLast Text 255
PCPClinic Text 255
LastSeen Text2 55


I have multiple excel sheets that I need to import but haven’t been able to figure out how to get these split and yet keep referential integrity.

Any help is appreciated, thanks!
 

Guus2005

AWF VIP
Local time
Today, 16:25
Joined
Jun 26, 2007
Messages
2,645
attach the xl spreadsheet as a table in Access and run a few queries to create the one-to-many relationship.

First fill the memberinfo table.

HTH:D
 

Users who are viewing this thread

Top Bottom