Toad 10 export dataset to xml (plain)

 Message from: polorzelpolczajka 

Hi All,
if there's any solution in Toad 10 to export dataset to xml (plain) and not including "header" information.
I mean when you open xml in Notepad to have data starting directly from  , and not to have  xml verison (...)  DOCTYPE main and so on..

When I export file and open in Notepad I have the following:
[i][b] 
 !DOCTYPE main [
   
   
   
   
   
   
   
   [/b]

 
   
     2012/01/02 00:00:00 
     4021 
     4153 
     9029 
     1992 
   [/i]

When I trying to import xml file to excel I have the following error:

[i]Error Code: -1072896636
URL :  
Reason: DTD is prohibited
Line 2:
Column: 11
File Offset: 34[/i]

When I delete header in XML and import file everything works like a harm.

Thanks for help.
BR
polo

_______________________________________

Historical Messages 


Author: Sylwester Nowak
Date: Thu Jan 26 05:59:50 PST 2012
Hi All,
if there's any solution in Toad 10 to export dataset to xml (plain) and not including "header" information.
I mean when you open xml in Notepad to have data starting directly from  , and not to have  xml verison (...)  DOCTYPE main and so on..

When I export file and open in Notepad I have the following:
[i][b] 
 !DOCTYPE main [
   
   
   
   
   
   
   
   [/b]

 
   
     2012/01/02 00:00:00 
     4021 
     4153 
     9029 
     1992 
   [/i]

When I trying to import xml file to excel I have the following error:

[i]Error Code: -1072896636
URL : 
Reason: DTD is prohibited
Line 2:
Column: 11
File Offset: 34[/i]

When I delete header in XML and import file everything works like a harm.

Thanks for help.
BR
polo
__
_______________________________________