i have some questions, i receive an excelfile on a daily base. This excel file should be imported into a database.I have a couple of questions about it.
1. Every line in the excelfile represents one record, but there are a lot of fields, like a persons name, adres, city. But also about items he or she has purchased. Now my idea was to create two seperate tables for the persons and for the items, than create a table for the join of the person and the purchased item. Would this would be a proper way, or should i leave all items in one table?
2. in case of creating two different tables, what would be the best way to extract the data en divided it over the two tables? so that a relationship stands..
I am using SQL2008 (MS)
Thanks in advance !!
View Complete Post