multiple xml imports from local path

I'm struggling with the import of xml files in access.

I receive the files in outlook and save them as client(1).xml, client(2).xml
etc in a local folder.
When I'm using the xml import function in code I only can import a file I
named in the code.

example:
Application.ImportXML DataSource:="D:\Clienten XML\client.xml",
ImportOptions:=acAppendData
(I can put in the same rule with client(2).xml etc, but there are a lot of
files this way).

This works fine but how can I tell the import engine that I want to import
all the *.xml files from "this location" etc.

I think I have to use a loop but I don't know how to define the code.

Can somebody help me?

Thanks
.

Relevant Pages

  • Help with vbscript please - delete files
    ... I know a little about VBscript but am struggling with trying to figure out ... I need to delete all .xml files from a certain directory, however, I need to ... delete only certain ones based off of client names. ... I am trying to write the script to where it will if files exissts then ...
    (microsoft.public.scripting.vbscript)
  • Automating import of XML files received in Outlook
    ... I regularly received XML files by email and would like to set up outlook to ... then extracts the data in the attached XML file to the designated database. ... I've taken a quick look at the Outlook rules and assume I need to select ...
    (microsoft.public.access.externaldata)
  • Re: Automating import of XML files received in Outlook
    ... This is the wrong place to ask about programming Outlook. ... - the rest should be straightforward Automation. ... >I regularly received XML files by email and would like to set up outlook to ... >then extracts the data in the attached XML file to the designated database. ...
    (microsoft.public.access.externaldata)