> I have an Excel spreadsheet that will eventually become a database. Being a > flat file, the column information is very repetitive. I'm hoping that with > a handful of clever queries, I can populate this data into normalized > relational tables. If anyone has any advice or URLs that would help in > making this easier, I would appreciate it. :)
Read up on normal forms. Most people recommend going up to third normal form, but it depends on your situation. Here's normal forms as I (somewhat) remember them: First Normal Form: No repetitive columns. (i.e. Don't have columns called color1, color2, color3, etc...) Second & Third Normal Form: Well... I forget what each one is, but basically, everything should relate directly to the primary key. If you have a table called "People" with an primary key of PersonID, then all attributes should relate directly to that a person. For instance, you would want to have columns called EyeColor and NumberOfTeeth because those relate directly to the person. You wouldn't want to have MothersLastName or BrothersMiddleInitial because those do not relate to the person. Instead, you would have a MotherID that links to another row in the table People and perhaps an associative table to hold the brother/sister relationships since they are many-to-many relationships. Can you give us the columns for the flat file and perhaps we can better help you out? Ben Johnson Hostworks, Inc. ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

