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.

Nz87f4,

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

Cor

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?

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

Show quoteHide quote

Show Modal, then Again
TopMost without SetFocus
Get associated icon for a file
A question about finding class methods in the Help
WEBREQUEST AND WEBRESPONSE PROBLEM
Assigning a Value to a Structure Pointed to by a Tag ?
VB.NET profiler
Process output redirection?
Using a VB.net dll in VB6
How to know if a file is ready.