I would like to set up a script to query a publicly available XML file. I have used Microsoft Access in the past with scripts etc. but it's been a while, so I am hoping someone can point me in the right direction.
There is a publicly available XML file which is released from the Australian Business Register every few weeks.
(available from the links on the page titled 'ABN Bulk Extract Part 1' and 'ABN Bulk Extract Part 2')
It lists all of the Australian Business Numbers (ABNs) for Australian businesses.
What I would like to do is extract the new Australian Private Companies which have been registered in the state of the ACT (Australian Capital Territory) during the last release period.
I envisaged I would be able to do this by querying the following fields in the XML file:
EntityTypeIn = PRV
EntityTypeText = Australian Private Company
State = ACT
ABNStatusFromDate = 20180117
The latest release date is the 31 January 2018 and the previous release date was the 16 January 2018, so I thought I could extract the dates for businesses registered in between those release dates, 20180117, 20180118, 20180119, and so forth.
I have downloaded the XML and imported using the Get External Data function, however it doesn't import the folder structures correctly so I couldn't query the ABNStatusFromDate.
I realize it is possible to work around this by using a script but I am not familiar enough to be able to do this. The files are quite large and I wasn't able to import into Excel because it ran out of memory.
If someone can help with this it would be greatly appreciated.
Many thanks Cathryn