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

Reply via email to