Import XML Files Into Access 2002

  • Thread starter Thread starter cksj
  • Start date Start date
C

cksj

In MS Access 2002, there's a functionality that will allow me to import an
XML file into the database.
Is there a way to do this programatically using VB.Net?

Thanks for any ideas.

Cesar
 
Yes. There are all kinds of XML base classes, methods, and properties .NET
that are all usable in VB.NET.

The problem is that this group is for Microsoft Access.

For VB.NET questions, you need to use one of the 4 VB.NET groups that all
start with microsoft.public.dotnet.languages.vb.

I'd also try the .NET XML group at microsoft.public.dotnet.xml.

You might also take a look at the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;313651.

Good luck.

Sco
 
¤ In MS Access 2002, there's a functionality that will allow me to import an
¤ XML file into the database.
¤ Is there a way to do this programatically using VB.Net?
¤

You can use the ImportXML method of the Access Application object via automation or you can use the
various XML classes to read the file in and write the data out line by line. Take a look at the
Using .NET DataSet Class example at http://www.perfectxml.com/articles/XML/ImportXMLSQL.asp. You
should be able to adapt it for an Access database.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Hi,

You first have to find out if the XML file is a document or a dataset or
whatever.

However when it is a dataset you can do it in a different way than with what
I call a document.

For the first you can go for methods using the dataadapter, for the second
one you can use a xmlreader of use the methods as Paul sugested.

I hope this gives some idea's

Cor
 
Back
Top