I know that I can build something to do this with relative ease but I'm wondering if there is something that already exists that I can use:
We've built site for client based on relational database. Some of the attributes are Many to Many relations. Client provides us with spreadsheet of data to import that contains comma separated value list of attributes. In some cases, said value list spans multiple rows. Besides throttling the client, my goal is to have a spreadsheet (or table, which is where the data will end up) with something closer to a many-to-many feel with item number/name in one column and attribute value in another. Then I can write an INSERT statement to make the correct tie using joins. Anyone have such beastie that I can borrow? Thanks! Hatton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298088 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
