[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1173
  • Last Modified:

Automating XML Import to Access 2002 with VBA

Hi,

I have five xml files which I'm wanting to import automatically through VBA into an access 2002 database.

Is there a nice easy snippet of VBA code that I could use, that would also be easily transportable if I decide at a later date to make this into a proper VB app?

Cheers.
0
JoHarris
Asked:
JoHarris
  • 2
1 Solution
 
Alan WarrenCommented:
How were  the xml files created?

if you created them by persisting an ADO.Recordset as  XML, it's relatively easy to open the XML as an ADO.Recorcordset and parse the  fields into a table.

Check this site:
Persisting an ADO Recordset to XML
http://www.vbxml.com/xml/guides/developers/ado_persist_xml.asp


Alan
0
 
JoHarrisAuthor Commented:
They were created by a third party application but are easily imported through Access' file menu.  I'll go and have a look at the ado link, that sounds as though it should do the trick.
0
 
JoHarrisAuthor Commented:
That did the trick - thanks heaps!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now