Importing XML File into an Empty Access Table

[nz87f4]

I recently created an empty table with absolutely no fields/columns
using ADOX. I have an XML file with both data and a scheme that I
would like to import into this table. Is it possible and if so how
would I go about it? If there is a better way or perhaps the only way
please let me know that as well.


Prior to answering this question I have already imported data into an
existing structured table using readxml and update.


Any help with this would be greatly appreciated.

 

[Cor Ligthert [MVP]]

Nz87f4,

There is not really a standard method for that.
And that is probably what you ask.

Cor

 

[nz87f4]

What would be the best way to take the data and scheme in my XML file
and create a Database table within Access using VB.net?

 

[Cor Ligthert [MVP]]

NZ

Probably looping through the DataColumns in the datatables of the XML and
than use this sample and replace the creating of the table columns by the
loop. (Assuming that you did not use relatinons in the XML).

http://www.vb-tips.com/default.aspx?ID=e76b8450-4c8a-4662-8f41-d6dda3c888c8

I had the idea that I have once made a sample for it, however I cannot find
it at the moment.

I hope this helps,

Cor