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

[kawai6rr]

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]

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