Cowboy_BeBa
Registered User.
- Local time
- Today, 09:05
- Joined
- Nov 30, 2010
- Messages
- 188
Hi
Im working on a project and am considering using access, essentially im building a weather app (just a university project, not an actual app), ive checked and using access is permissible (though it is recommended i use java)
essentially i need to get the db to both download a json file from a url and then deserialize/parse it and create an update query to add the data to a table
the update query part should be easy enough (once i have variables storing the data from the json file i should have no trouble writing the query), however im unsure how to download the file (and save it to a set location) and actually have the db read the file in VBA
just wanted to check if this is possible and if someone could steer me in the right direction?
Im working on a project and am considering using access, essentially im building a weather app (just a university project, not an actual app), ive checked and using access is permissible (though it is recommended i use java)
essentially i need to get the db to both download a json file from a url and then deserialize/parse it and create an update query to add the data to a table
the update query part should be easy enough (once i have variables storing the data from the json file i should have no trouble writing the query), however im unsure how to download the file (and save it to a set location) and actually have the db read the file in VBA
just wanted to check if this is possible and if someone could steer me in the right direction?
Last edited:
