HI All.
I have come back to looking at loading XML files into ADO Tables for a
small project I am looking at.
If I take a standard (if there is such a thing) XML file and try to load
it into an ADOTable it tells me the XML file is incomplete or invalid.
I then ran a query via an ADOQuery, then did savetofile the did
loadfromfile into the ADOTable, and it works.
Ok, so I then looked at the XML, and its got headers that I have never
seen before, but I can see what its on about.
My main question IS, I will be getting the XML data from SQL Server 2000
which lets you do, SELECT * FROM Products FOR XML,AUTO which will
export to XML.
Does anyone else do this, or similar ? how do I get SQL Server to
generate the headers that the ADOTable seems to need etc?
Thanks, Jeremy
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
