Member Avatar for sutanu_halder

How to import Xml file into a table in MS-ACCESS database using Visual Basic 6.0?
Please Help Me.....

  • 3 Contributors
  • 3 Replies
  • 2K Views
  • 2 Years Discussion Span
  • Latest Post Latest Post by DWOffutt
Member Avatar for sutanu_halder

I use Microsoft Access 2000.Is it possible to import the XML files using Visual Basic 6.0?

Member Avatar for ac001

Here is the code to add shippers table to the test.mdb:

Dim appAccess As Object
    Dim dbname As String, xmlFile As String
    dbname = "C:\test.mdb"
    xmlFile = "c:\shippers.xml"
    Set appAccess = CreateObject("Access.Application")
    appAccess.OpenCurrentDatabase (dbname)
    appAccess.ImportXML xmlFile
    appAccess.CloseCurrentDatabase
    appAccess.Quit acExit
    Set appAccess = Nothing

Note: you need to add the reference Microsoft Access 9.0 Object Library to your VB6 project.

Member Avatar for DWOffutt

This code works great except that it opens the application Access to which you have to reply before going on. Can that be suppressed?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.