I have a text file which looks like this
123456 Amanda Morris
and I would like it to look like this
The file has about 2000 lines how would I go about inserting the quotes and the commas.
I use textpad to open the textfile and I am using sql server 2000.
Thanks in advance for you help.