It's not very clear what you are trying to achieve. The first 2 zip codes in your fields are repeating, and then the next three are not. If you give a better example of what the data should look like from your sample xls file, then it will be easier for people to help you.
Russ > -----Original Message----- > From: morchella [mailto:[EMAIL PROTECTED] > Sent: Friday, January 25, 2008 2:10 PM > To: CF-Talk > Subject: "zip code" range from xls to sql > > 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:297473 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
