JamesAccess2008
New member
- Local time
- Tomorrow, 08:19
- Joined
- Aug 15, 2008
- Messages
- 1
Hello,
I would like to import data everyday from a public website listing court lists into a database.
The source website is http://www.magistratescourt.tas.gov.au/lists/Hobart_Criminal
I want to pull each list from each area into a different table, but ideally I should be able to search one database for the information.
I have tried this with excel, but it does not refresh but replaces the information on each import.
I also have my own domain name, so could stick something online to just automate this each day.
My ideal situation: not to manually download this information each day, but to have a populated database available that is automated.
Thanks in advance.
Regards,
James
I would like to import data everyday from a public website listing court lists into a database.
The source website is http://www.magistratescourt.tas.gov.au/lists/Hobart_Criminal
I want to pull each list from each area into a different table, but ideally I should be able to search one database for the information.
I have tried this with excel, but it does not refresh but replaces the information on each import.
I also have my own domain name, so could stick something online to just automate this each day.
My ideal situation: not to manually download this information each day, but to have a populated database available that is automated.
Thanks in advance.
Regards,
James