Is there a way, using simple ADO, to open the XML file directly? No editing 
is necessary ... all we need to do it open the file into an ADO recordset 
object and then use that recordset to append to another recordset based on a 
SQL Server table. Some of the XML files are HUGE, so I didn't think I could 
use the built-in SQL Server XML support since all of the documentation seemed 
to indicate I'd have to send the XML text as a parameter to a stored 
procedure. I can do that for the smaller XML files, but what about the larger 
ones? So it would seem that the easiest way would be to open the XML file 
directly from the ado recordset object.

Thank you,
Brad

"Jonathan Chong" wrote:

> 1. Download MSXML 4 from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=3144b72b-b4f2-46da-b4b6-c5d7485f2b42&displaylang=en
> 2. Look for example provided in XML 4.0 parser SDK and I believe there are
> lots of example in VB.
> 
> "geno" <geno@d...> wrote in message
> news:4AEC928F-7532-404C-8B93-CF7076956800@m......
> > In my VB 6 app, I will be receiving an xml string containing many records
> > from a web service.  What is the best method to use to parse out the data?
> 
> 
>