Return
-
Title
Exporting Data Set to HTML Table and then pasting to Word, does not display in table format, just as text with HTML tagging. -
Description
When exporting the results of a query to an 'HTML Table' and selecting the output to the Clipboard, the table is not displayed when pasted into a Word document. It just displays as text with the HTML tags. e.g
<TABLE id="" cellSpacing="1" cellPadding="1" width="100%" border="1" ><TR><TD>CUSTID</TD><TD>FNAME</TD><TD>LNAME</TD><TD>ADDID</TD><TD>STATE</TD><TD>NOTES</TD></TR><TR><TD>1</TD><TD>Joe</TD><TD>Smith</TD><TD>123</TD><TD>CA</TD><TD>resident</TD></TR><TR><TD>2</TD><TD>Jane</TD><TD>Smith</TD><TD>123</TD><TD>CA</TD><TD></TD></TR><TR><TD>3</TD><TD>Jack</TD><TD>Smith</TD><TD>123</TD><TD>CA</TD><TD></TD></TR></TABLE> -
Cause
This is as designed. Notice that the option is to copy to Clipboard or copy to an HTML file. If it is saved as an HTML file and opened up, the tags will be interpreted and a table will be created with the data set. If sent to the Clipboard, then it will be copied as straight text which includes the html tagging. This would be pasted as straight text in Word. -
Resolution
Save the dataset as an HTML file. Open the the HTML file in Word, and it should recognize the table structure. The file can now be saved as a Word document (docx) and the table formatting will be retained.