Importing strucrtured XML data int Access 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a well formed, valid XML file that I need to import into Access. The
XML file has a number of complex types with "nested" elements. When I try to
import the data Access creates a seperate table for the "nested" elements.
This is okay, but it does not put a link from the primary table to these
child tables .This means I have no way of knowing what row in Table A
corresponds to what row in Table B.

Is there a way to correct this?

thanks
mitch
 
Hello,

I have a well formed, valid XML file that I need to import into Access. The
XML file has a number of complex types with "nested" elements. When I try to
import the data Access creates a seperate table for the "nested" elements.
This is okay, but it does not put a link from the primary table to these
child tables .This means I have no way of knowing what row in Table A
corresponds to what row in Table B.

Is there a way to correct this?
Click to expand...

I'm not entirely sure, but I know that when I looked into this same issue, I ended up just writing my own XML Import
utility. Once I got my head around the whole DOM strucutre, it was pretty straightforward ... lot of code, and lot of
For Each loops to iterate the Nodes, but at least I know where my data is going.
thanks
mitch
Click to expand...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
Back
Top