July 18, 2010 at 2:55 pm
I am trying to export a table(sql server 2005) into a excel file using import/export wizard.
one column data in table have plenty of comma's, double cotes, etc.
I need to add escape character to the beginning and end of the entry to denote the string.
Lets say tablename is table1
i have 8 columns and i need to do this on 2 nd column.
can anybody provide the script to do this. thank you
July 19, 2010 at 6:30 am
I guess it would depend on how you are reading the file, but usually double quotes (") are what you use to wrap a string column on a CSV.
August 10, 2010 at 1:16 pm
Can u plz b detailed , like wt is ur requirement & how is the data in ur table..
August 10, 2010 at 1:29 pm
Yeah, if you are still having trouble, please do describe the process your attempting to complete. Though double quotes are the usual, you could really use any character in your CSV. Most importing allows you to enter any character as the text qualification for importing procedures. So with that being said, you should be able to use any off character as long as your importing allows for this variation. (~, @, ^, ect...)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply