I don't understand the business logic of ">from_zip to_zip >20106 20106 " (same value for from and to).
But sql-wise, it would be real simple, once you 1) finish import the excel into a db table, your table may look like this: zipTbl zipFrom 20106 22002 .... Then 2) alter your zipTbl by adding another column/field of zipTo; 3) then just run an update statement like this update zipTbl set zipTo = zipFrom; It should do it unless I misunderstood your question. >hey guys! >i need a little sql help/advice. > >i have a table that has 2 columns >from_zip >to_zip > > >i get xls files from people in the office with massive zip entries. >like: >Zip Code >20106 >22002 >22401 >22402 >22404 >22407 >22408 >22412 > >i want to go through this file and create the from/to fields... >from_zip to_zip >20106 20106 >22002 22002 >22401 22402 >22404 22404 >22407 22408 > >where do i start.... >i can import the xls as a new table in sql server. >then i would like to great a view to do the from to by a id that i have... >not sure if i am explaining this right at all... > >thanks for your help.. >-m ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:297466 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
