[AccessD] Parsing XML from SQL

[Ryan W]

Thanks let me read over this!





On Fri, Aug 20, 2021 at 12:48 PM jack drawbridge <jackandpat.d at gmail.com>
wrote:

> Ryan,
>
> I found this article/link via Google
> <
> https://docs.microsoft.com/en-us/office/troubleshoot/access/import-attribute-centric-xml
> >,
> and it's dated 2021. I'm not an XML person and have not tried the sample.
> But it may offer some insight.
>
> On Fri, Aug 20, 2021 at 12:36 PM Ryan W <wrwehler at gmail.com> wrote:
>
> > If I were to write a view or a procedure that returns a one row result
> that
> > is basically a big chunk of XML, what would be the best way to parse that
> > back into tables at the MS Access side?
> >
> > I'm using attribute based XML instead of ELEMENT based XML because I find
> > it more compact and easier to read, if that helps guide the assistance
> one
> > way or another.
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>