I need to read the contents of a comma or tab delimited .txt file, and have the contents placed in the appropriate fields in a database. For example, the text file will look like:
Course name 1 First person 2 second person 3 third person etc. The database will have a "course_name" field, and a "first", "second" "third" up to "twenty". I need to enter the course name in the course_name field, then enter the first person's name into the "first" field, second person's name in the "second" field, etc. I will have a number of course files, and will need to do each. Any help would be appreciated. Tim __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
