I have built an access database which just now I use to;
1. Load in XML file. (External Data > XML File)
2. Run a macro containing multiple queries (these queries add records to a table which build up an interface, which can loaded in to another program).
3. Repeat, until all files have been run through.
This was great at first due to only dealing with a small amount of XML files, but now the amount of files has grown and will only continue to increase. I would like to know if there is any way to make this automated, for for instance for access to run through every file in a directory.
I would like to know if this is possible to do using VBA?
Thanks.
1. Load in XML file. (External Data > XML File)
2. Run a macro containing multiple queries (these queries add records to a table which build up an interface, which can loaded in to another program).
3. Repeat, until all files have been run through.
This was great at first due to only dealing with a small amount of XML files, but now the amount of files has grown and will only continue to increase. I would like to know if there is any way to make this automated, for for instance for access to run through every file in a directory.
I would like to know if this is possible to do using VBA?
Thanks.