importing xml data

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

Hi,

I am currently using Access 2003 and have a simple
database with a table that stores users details. At the
moment I ave another system where the users details are
saved to an XML document where the XML fields match the
fields in the Access table. Is there any way that I can
import the data from the XML file into access ?

If there is , can I then make this process automatic i.e.
so that access checks every so ofter for new xml files and
automatically updates the information into a table.

Thank you for your time

Dave
 
File
Get External Data
Files of Type = *.xml

Test it out on a new .mdb file first.
See what it does.
See if it is what you want.

Then try it on a test copy with existing tables.
Did it work as expected?

Try it for real.
 
Back
Top