you know, you might not have to do that much work after all. you could use MS Access to import the information into an access database. after that, you can cut and paste the information into different tables and create relationships. if you really want to get jiggy with it, you can then use the upsize wizard to smack the puppy into a SQL database. so you fear of this job being 4 weeks, turn into 4 hours. gotta love Microsoft (oops, did i say that).
Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -----Original Message----- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 4:00 PM To: CF-Talk Subject: Re: OT: Making normalized tables from a single flat file. Well, I don't know how much cleverness is involved... its just drudgery, but the sooner you start the better off you'll be. Design your proper tables, write your queries (and no doubt toss in a few loops) and off you go. Do you have any specific questions on the process? --Matt-- ______________________________________________________________________ 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

