Colin Adan

Colin Adan

  • NA
  • 13
  • 0

HELP - How to import xml data into Microsoft Access

Jul 10 2006 3:23 AM
Hi All

I am trying to parse an XML file, strip out the data I require and insert this into a Microsoft Access Database Table. As the files are quite large, I thought about loading say the first 100 records into a DataGridView (hidden), calling a method to insert those into the database, then getting the next 100 records and so forth.

Does anyone have a clue how to do this? I can get teh data from the xml using ReadXML(), but that gives me the whole document.

If you know of a better way to go about this, I would love to hear it.

Many thanks
Col

Answers (2)