suppressing HTML tags | why can't data be copied directly from Query Analyzer into Excel after upgrading to Office 2007?
-
2012년 3월 15일 목요일 오후 5:58
I am using Query Analyzer to access a SQL database via. 2 problems:
Problem #1:
Before upgrading to Office 2007, I could copy my results directly from Query Analyzer to Excel with not problem. Now I just get garbage and have to save to a file with a .rpt extension, then import into excel. Is anyone else experiencing this - suggestions/solutions? Very annoying and time consuming.
Problem #2:
One of the fields being extracted is a description field with HTML tags, which I don't need and can't seem to convert or import cleanly. Can anyone help me mask/suppress these tags in my SQL statement?
Thank you.
Kdoyle
모든 응답
-
2012년 3월 16일 금요일 오전 9:48
Hello katiedoyle,
#1: Select "Result to text" (Ctrl + T)
Select the menu Tools|Options ... then select the result tab and select in the "Results output format" to "Tab delimeted"
Now yu can copy the result und past it to Excel.I wish you a nice day,
Torsten Schuessler- 답변으로 표시됨 Kalman TothMicrosoft Community Contributor, Moderator 2012년 3월 21일 수요일 오전 5:57
.png)
