Quote Originally Posted by mc12345678 View Post
I would then copy and paste column E to a new worksheet and export the data to a CSV file (to support text capturing the data to feed back into the database). with the delimiter being an enter or carriage return or similar.
Unfortunately the time had elapsed for me to modify the message again; however, the above statement was incorrect when performed by the majority of people using Excel. More correctly:

I would then copy column E and paste (paste special->values) in a new worksheet and then export the worksheet to a CSV file (to support text capturing the data to feed back into the database). (At least with Excel (again there is a more preferred/consistent application recommended for CSV export) this will place each row (SQL Statement) on its own line and the contents of the file can then be copied/imported into the SQL processor of choice.)