Found the below code to be working, but have two constrains. Each rows from the source file is copied in the last empty column. The string is gets pasted with double quotes.
Sub ImportCSV()
<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida...