Thanks, I will check out the site, but the data is not coming out of a csv file, its already been formatted and now exist in another SQL table. It basically comes down to breaking one record from one table, to as many duplicate records to another table, except for the product field, depending on how many products exist in the field.
So if there is one record with five products in table one, once exported to table two, it will be 5 records, with one product for each record. Thanks for your help. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 1:48 PM To: SQL Subject: Re: SQL HELP I recommend that you check out http://www.sqlteam.com/ and look at the articles on using CSV data. If you substitute a space for the comma as your delimiter, you should be all set. |----------------------------------+------------------------------------ --| |Eric A. Laney |Don't use no double negatives. | |Systems Architect | | |Verizon Security | | |Voice: 813.293.3093 | Another English Lesson| |Pager: 888.551.3718 | | |----------------------------------+------------------------------------ --| ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
