Thank you for the response. I have tried this. The column order in the
spreadsheets have been moved around from the actual SQL text column
order. WHen i copy and paste as you suggested and re-execute the order
is out of whack. Usually not a problem but whoever re-adjusted the
columns in the spreadsheet did so with the intention they wouldn't
change again (basically they can't change). Just a pain in the butt
due to the number of fields involved.

Thanks for your help!


--
jmancuso
------------------------------------------------------------------------
jmancuso's Profile: http://www.excelforum.com/member.php...o&userid=25132
View this thread: http://www.excelforum.com/showthread...hreadid=386312