InstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 21 Nov 2009 23:25:37 GMT20http://www.sqlservercentral.com/Forums/Topic739596-8-1.aspxThe SQL script is part of a SQL file that contains several exports to excel sheets. I have them all working fine, but because the xmlconfig col of the applications table contains fully qualified XML I need to find a way of exporting this information as well. I could create a txt file, but I'd prefer to keep all exporting to excel as the SQL script is part of a batch file run to obtain backups from remote sites.Mon, 22 Jun 2009 12:41:02 GMTWayne Atherton-398733http://www.sqlservercentral.com/Forums/Topic739596-8-1.aspxI'm pretty sure Excel won't allow you to do that.Why not export the XML to text files instead of Excel?Mon, 22 Jun 2009 12:18:35 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic739596-8-1.aspxHi there,I have some xml stored in a table col of type TEXT, can anyone assist me getting this correct using the following:INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\ExtractTables\ExcelFiles\SQL2000\SQL2000Tables.xls','SELECT * FROM [ApplicationXMLConfig$]')SELECT xmlconfig from DatabaseName.dbo.ApplicationsI keep getting a truncate error message because the values are greater than 8000 chars (i think)Mon, 22 Jun 2009 11:15:46 GMTWayne Atherton-398733