Results 1 to 5 of 5
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    XML import into Access (Access 2003 SP2)

    I have a need to import an XML file into Access, is there any utilities in Access or has someone done this before?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: XML import into Access (Access 2003 SP2)

    You can use File | Get External Data | Import... interactively, and Application.ImportXML in code.

    See:
    Using the XML Features of the Access 2003 Object Model
    New XML Features in Microsoft Office Access 2003

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: XML import into Access (Access 2003 SP2)

    I thought you had done this yourself lots of times Pat. You have asked questions about it a few times.

    In File...Get External Data...Import you can specify an XML file as the source. Is that enough ?
    Attached Images Attached Images
    Regards
    John



  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: XML import into Access (Access 2003 SP2)

    I was wrong, i have Access 97 that needs to do it.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: XML import into Access (Access 2003 SP2)

    Access 97 doesn't have built-in support for the XML format. You'll have to write your own code, perhaps using MSXML. You'd have to make sure that the correct version of MSXML is installed on all target PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •