[thelist] populating a 3 NF relational database with spreadsheet data
Smith, Jason, (C)
CSmith3 at dow.com
Wed Dec 3 13:41:03 CST 2003
I have developed a relational database from a spreadsheet and now need to get the spreadsheet data into the tables. I checked the archives of this list and found info that helped me to get most of the data into the right tables.
Now I have one final table to populate and this has a unique problem. The spreadsheet data has a primary key with varying numbers of fields associated to it.
I could paste the data into the table but there too many items and it is not reasonable to do so. I am a stumped as what to do next. Here is an example of the spreadsheet data and another example of the target table.
Thanks for any help..........
ID Field1 Field2 Field3 Field4 Field5 Field6
1 Magnolia Cold Bed Jenny Brown Grave
2 Meat Not Wrong Web Caledonia Joe Teller
(note: the data is tab delimited)
[here is the table]
ID Song Position
1 Magnolia 1
1 Cold Bed 2
1 Jenny Brown 3
1 Grave 4
2 Meat 1
2 Not Wrong 2
2 Web 3
2 Caledonia 4
2 Joe 5
2 Teller 6
__________________________
Jason Charles Smith
More information about the thelist
mailing list