Have you tried FOR XML RAW ? Stephen
-----Original Message----- From: vss [mailto:[EMAIL PROTECTED] Sent: Wednesday, 30 July 2003 1:38 p.m. To: Multiple recipients of list delphi Subject: [DUG]: ADOTables and XML files 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/ Disclaimer : This communication contains information that is confidential and the copyright of enSynergy Limited or a third party. If you are not the intended recipient of this communication please delete and destroy all copies and telephone enSynergy Limited on +64 9 9205441 immediately. If you are the intended recipient of this communication you should not copy, disclose or distribute this communication without the authority of enSynergy Limited. Any views expressed in this Communication are those of the individual sender, except where the sender specifically states them to be the views of enSynergy Limited. Except as required by law, enSynergy Limited does not represent, warrant and/or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. --------------------------------------------------------------------------- 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/
