Can't read xml to Excel (dataset.WriteXml)

  • Thread starter Thread starter Morten Snedker
  • Start date Start date
M

Morten Snedker

I'm using this code to generate an XML-file:

If File.Exists("d:\k2b.xls") Then File.Delete("d:\k2b.xls")
Dim fs As New System.IO.FileStream("d:\k2b.xml",
IO.FileMode.CreateNew)

dsP.WriteXml(fs)

fs.Close()
fs.Dispose()


When importing to Excel 2000 (10.0) it shows the entire xml-code (as
if opened with text editor). I'm I doing something wrong?


/Snedker
 
Morten said:
I'm using this code to generate an XML-file:

If File.Exists("d:\k2b.xls") Then File.Delete("d:\k2b.xls")
Dim fs As New System.IO.FileStream("d:\k2b.xml",
IO.FileMode.CreateNew)

dsP.WriteXml(fs)

fs.Close()
fs.Dispose()


When importing to Excel 2000 (10.0) it shows the entire xml-code (as
if opened with text editor). I'm I doing something wrong?
Click to expand...

If you save it with an extension of .xls instead, does Excel then
"understand" it?

Andrew
 
Back
Top